MS Access: JOIN ON two conditions

Databases
1

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.

2

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 )

3

Arghhh that’s it, thanks for your light speed reply.