[MS ACCESS] Join expression not supported with LEFT JOIN

[DaveMaxwell]

@r937

i would really love to hear your reasoning why the basic logic of a join which requires two conditions should be changed to require only one of them

Argh. Typo…of COURSE you’d find it.

I meant to say change the AND to ON since the first LEFT JOIN seemed to allow for it (though it made no sense to me how it worked)

But it looks like the answer is simpler, and Rudy has already posted it in an earlier thread. Wrap the two conditions in parenthesis…

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.

So, the condition would be

INNER JOIN dbo_FacturesClientsArticles ON ([dbo_Factures Clients].NoFacture=dbo_FacturesClientsArticles.NoFacture AND dbo_Articles.NoArticle=dbo_FacturesClientsArticles.NoArticle)