Access 2010: Syntax error (missing operator) in query expression

by

In Access you need parentheses when you have more than one join:

FROM (drugs as a 
  INNER JOIN warehouse as b
    ON a.ID = b.drug_id) 
  INNER JOIN pharmacy as c 
    ON b.drug_id = c.drug_id

More Related Contents:

  1. How to simulate UNPIVOT in Access?
  2. Top n records per group sql in access
  3. Achieving ROW_NUMBER / PARTITION BY in MS Access
  4. CONCAT equivalent in MS Access
  5. Get Parent with multiple children in desc order
  6. Aggregate columns with additional (distinct) filters
  7. How to avoid the “divide by zero” error in SQL?
  8. How do I do top 1 in Oracle? [duplicate]
  9. Multiple INSERT statements vs. single INSERT with multiple VALUES
  10. Using an ORM or plain SQL? [closed]
  11. Database Structure for Tree Data Structure [closed]
  12. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  13. sql ORDER BY multiple values in specific order?
  14. Dynamic SELECT TOP @var In SQL Server
  15. MySQL’s now() +1 day
  16. Can you access the auto increment value in MySQL within one statement?
  17. Generate script in SQL Server Management Studio
  18. Oracle SQL – Identify sequential value ranges
  19. ColdFusion adding extra quotes when constructing database queries in strings
  20. In SQL, is UPDATE always faster than DELETE+INSERT?
  21. How can I determine the status of a job?
  22. MySQL #1140 – Mixing of GROUP columns
  23. How can I select rows with most recent timestamp for each key value?
  24. postgresql – sql – count of `true` values
  25. unpivot with dynamic columns plus column names
  26. PostgreSQL where all in array
  27. How do I format date and time on ssrs report?
  28. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  29. How to Execute SQL Query without Displaying results
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment