Search code examples
sqlms-accessms-access-2007

FROM Statement Giving an Error (3 Sources)

I am trying to SELECT a few things from tables A,B, and C, but when I try to LEFT JOIN, I keep getting an error. My code currently looks like this:

FROM (A LEFT JOIN B ON A.id = B.id), C

Am I not allowed to left join two tables and include the entirety of a third?

Thanks for your help.

EDIT Here is a sample code:

SELECT A.ID, A.place, A.receipt, D.State, A.service, B.Description, C.ID, C.receipt, C.Source FROM B, (A LEFT JOIN C ON A.receipt = C.receipt), D;

Solution

  • Access doesn't support combining cross-joins with other joins, so you will have to do the left join in a subquery, and then the cross-join:

    FROM (SELECT * FROM A LEFT JOIN B ON A.id = B.id) As D, C