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 … Read more