Query using combo of first and last name

[derekstewart]

I maintain a 15000 record employee file with SS# as the primary key. I have been given a list of 250 first and last names and have been asked to pull info about these people. I am trying to figure out how to query this info using a combination of first and last name. I tried to use the query builder and connected first name and last name from the file to first and last in the table but that didn't work. I can do last name alone or first name alone, but that returns 1800 records and isn't much good. Any help would be appreciated.

 

[benmillus]

Have you tried?

EMPTBL = the 15000 record table.
LNFNTBL = the table with only last name (LN) and first name (FN).

SELECT EMPTBL.*
FROM EMPTBL, LNFNTBL
WHERE (EMPTBL.LN = LNFNTBL.LN AND EMPTBL.FN = LNFNTBL.FN)
ORDER BY EMPTBL.LN, EMPTBL.FN;