Search in a Table, values from other

  • Thread starter Thread starter Chasqui
  • Start date Start date
C

Chasqui

Hi, I wonder how can I filter records from table1 present in table2
table1 have 100K recs. and table2 have 10K recs.
both tables fields is LASTNAME
Thank you for your help.
 
.... and if you have 50 Smith's in Table1 and 10 Smith's in Table2, how do
are you going to match which Smith in Table1 to which Smith in Table2.

Suggest you may have to think more of the selection strategy...
 
Excuse me, my mistake....
Table1 has many records with the same lastname,
Table2 has only one record of a kind.
Thank you for your help
 
I am not sure what you need but try:

SELECT Table1.*
FROM Table1 INNER JOIN Table2
ON Table1.LastName = Table2.LastName
 
Back
Top