Double LEFT JOIN on Microsoft Access

For future reference, and to serve as recipe in the library, if you want to do more than one LEFT JOIN in Microsoft Access, you have to use parenthesis in the FROM clause.

Tipical Query:
SELECT a.columna, b.columnb, c.columnc
FROM tablea AS a LEFT JOIN tableb AS b ON a.id = b.id LEFT JOIN tablec AS c ON a.id = c.id

To work in Microsoft Access you have to use as following:
SELECT a.columna, b.columnb, c.columnc
FROM ((tablea AS a) LEFT JOIN tableb AS b ON a.id = b.id) LEFT JOIN tablec AS c ON a.id = c.id

Otherwise, you get a “Missing Operator” error and you can loose you head in the middle.

14 thoughts on “Double LEFT JOIN on Microsoft Access

Leave a Reply

Your email address will not be published. Required fields are marked *