Find records in one table that match records in another

  • Thread starter Tom via AccessMonster.com
  • Start date
T

Tom via AccessMonster.com

Hi
I need to find the records in one table that match the records in another
table. All the SIPID records in tblSIP that match the SIPID in tblBusiness.
How do I put this in an expression in a query?

Thanks
 
K

KARL DEWEY

SELECT tblSIP.*, tblBusiness.*
FROM tblSIP INNER JOIN tblBusiness ON tblSIP.SIPID = tblBusiness.SIPID;
 
T

Tom via AccessMonster.com

No, that didnt work. I was thinking of something like a DLookup. BusinessID
is the matching field in both tables.

What do you think?

Tom
 
Top