Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by IOOI
-
inner join on multiple fields (Access 2000)
I then tried using "import table", the inner join is working fine now.- IOOI
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
inner join on multiple fields (Access 2000)
I forgot to mention that the tables are linked tables from two different ODBC Data sources. Would this be the problem?- IOOI
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
inner join on multiple fields (Access 2000)
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
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
