Join more than 1 table

[KIM]

I wanna join two table with 2 key in Access Query, can I
do that..

Example:

select * from a Left Join b on a.key1=b.key1 AND
a.key2=b.key2

 

[John Vinson]

I wanna join two table with 2 key in Access Query, can I
do that..

Yes, up to ten fields.

Example:

select * from a Left Join b on a.key1=b.key1 AND
a.key2=b.key2

Exactly correct.

Did you try it? Did you get an error?