Home | Pinoy Relihiyoso | Sitemap

Tuesday, July 2, 2013

Multiple JOIN in MS Access


When you query a multiple join in MSSQL you use this following 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

If you use the above query in  MS Access you will encounter an error message "Missing Operator". To resolve that error you should use the following 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

No comments :

Post a Comment