0

Getting syntax error saying

"Syntax error (missing operator) in query expression 'Products.[SupplierID] = Suppliers.[SupplierID] inner join Categories on Products.[CategoryID] = Categories.[CategoryID] where Suppliers.[Country] = 'USA' order by ProductName;'

I can't seem to find whats wrong with it.

The query code is below:

Select ProductName, CompanyName, CategoryName
from Products
inner join Suppliers on Products.[SupplierID] = Suppliers.[SupplierID]
inner join Categories on Products.[CategoryID] = Categories.[CategoryID]
where Suppliers.[Country] = 'USA'
order by ProductName;
Bohemian
  • 389,931
  • 88
  • 552
  • 692
gallonofbrando
  • 1
  • This is for Microsoft Access? While the query looks fine, MS Access has a strange join syntax that requires parentheses: See the accepted answer in https://stackoverflow.com/questions/7854969/sql-multiple-join-statement – Thorsten Kettner Sep 11 '21 at 05:15

0 Answers0