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

ms-access-2010, sql

Solution

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

Problem

I want to have three tables in my sql query but I get an error message. I have this sql code: ``` SELECT warehouse.expiry_date, pharmacy.expiry_date, drugs.active_substance, drugs.strength, drugs.strength_type, drugs.dosage_form, drugs.minimum_quantity, SUM(warehouse.in_quant)+SUM(pharmacy.in_quant)-SUM(warehouse.out_quant)- SUM(pharmacy.out_quant) AS Total_available_stock 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 GROUP BY warehouse.expiry_date, pharmacy.expiry_date, drugs.active_substance, drugs.strength, drugs.strength_type, drugs.dosage_form, drugs.minimum_quantity; ``` And i get the error: ``` Syntax error (missing operator) in query expression in 'a.ID = b.drug_id INNER JOIN pharmacy as c on b.drug_id = c.drug_i'. ``` Any help please?

Original source