I have two tables - tblMain and tblOT. Both tables have LAST, FIRST, and DOB fields. I'd like to find all of the records in tblOT that have a matching record in tblMain using LAST, FIRST, and DOB as the identifying fields.
I know this will match on LAST:
Select * from tblOT T1 where
T1.[LAST] in (select T2.Last from tblMain T2)
But I have no idea how to match on all three fields.
Thanks in advance for any help you can provide.