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
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