Results 1 to 3 of 3
Jul 5, 2007, 12:33 #1
MS Access: JOIN ON two conditions
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.
Jul 5, 2007, 12:44 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)
Jul 5, 2007, 13:03 #3
Arghhh that's it, thanks for your light speed reply.