SQL Help Needed!

[xjcass]

Hope this is the right group.
How do you connect two fields from one table to the second table's same field in Access????? If I try it direct, it wants a second copy of the second table. I also get the error msg saying "ambiguous outer join. Make one a query and then use the query in the select statement". I do this and get the error msg "Join not supported". I have several fields in the first table I want to go to the same field in the second table. I have tried an intermidiae table as well, but get the same ambiguous error.
Any help woud be greatly appreciated!
Thanks!

[Bullschmidt]

Here is an example joining two fields from tblInv to the same two fields in tblInv2 and showing all the fields from tblInv:

strSQL = "SELECT tblInv.*
FROM tblInv INNER JOIN tblInv2 ON (tblInv.InvUserID = tblInv2.InvUserID) AND (tblInv.InvID = tblInv2.InvID)"

[xjcass]

Thanks, J Paul! I could not figure this out for the life of me and could find no examples, so thanks!

[Bullschmidt]

Jim,

Glad it helped!