Is it possible to have more than one condition for a JOIN in MS Access?
If I do this, I get 'Join expression not supported.', caused by having the second JOIN condition:
SELECT Table1.SomeField, Table2.OtherField FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.Tbl1_ID AND Table2.JoinThisRecord = TRUE
Am I just using the wrong syntax? Or is it not possible to achieve this with Access? If so, it seems a bizarre limitation.
that should work
maybe with parentheses?
SELECT Table1.SomeField, Table2.OtherField FROM Table1 INNER JOIN Table2 ON ( Table1.ID = Table2.Tbl1_ID AND Table2.JoinThisRecord = TRUE )
Arghhh that's it, thanks for your light speed reply.
This topic is now archived. It is frozen and cannot be changed in any way.