Hi all! OK, I did some googling and couldn't find anything like this, so hopefully someone can tell me how it's done.
I am querying a few DBase IV tables and putting the results in VB tables. Now that I have a list of account numbers I need to match them up with another external DBase file. Can I do this with an inner join? This is the first part of the SQL: SELECT ContSupp.CONTSUPREF, ContSupp.CONTACT FROM ContGrps INNER JOIN ContSupp ON ContGrps.ACCOUNTNO = ContSupp.ACCOUNTNO Then I realized that the join SHOULD be on table3.accountno. So it should look more like this: SELECT ContSupp.CONTSUPREF, ContSupp.CONTACT FROM ContGrps INNER JOIN ContSupp ON table3.ACCOUNTNO = ContSupp.ACCOUNTNO But, of course, one table is internal and the other is external so that wont work. Is there any way to do it like this? Or would I have to do a separate query for each record in table3? Keep in mind I'm fairly new to programming so I might need a few details. Thanks! Scott
