Use results from query to search a different table

[bob2cam]

Hello, I have a table named inquiries. It contains 1,000 records and continues
to grow. I've been asked to take the firstName, and lastName from each record
and use them as search criteria against another database that contains about
6,000 records. So I'm faced with the delemma of running a 1,000 searches at any
given time... I haven't a clue as how to begin.. Any help or direction would
be greatly appreciated. Thanks, Bob

[BigDMorris]

Will this work?

SELECT *
FROM FirstTable, SecondTable
WHERE SecondTable.FirstName = FirstTable.FirstName
AND SecondTable.LastName = FirstTable.LastName

Dave Morris