inner join on multiple fields (Access 2000)

[IOOI]

This may look trivial to some.

I have two Access tables, each has a primary key consisting two fields. I want to inner join the two table on their compond primary key (two fields), but the result set looks like a left outer join.

Could anyone tell me what I missed? Thanks.

 

[IOOI]

I forgot to mention that the tables are linked tables from two different ODBC Data sources. Would this be the problem?

 

[IOOI]

I then tried using "import table", the inner join is working fine now.