Select data from two tables with different column 1

[tkleader]

Tab1 has two columns (Last:First) and Tab2 has one column Name). What I want to do is select all data where Tab1.last = Tab2.name and Tab1.first = Tab2.name. Here are some sample data:

Tab1.Last : Tab1.Last
Doe : John
Thomas : Barn

Tab2.Name
Doe
John
Jane
Thomas

Based on the data above, it should only display John Doe in Tab1 because both field matches the field in Tab2.

However, my query doesn't work. Please help.

 

[KenReay]

Hi

How about

SELECT * FROM Table1 WHERE Table1.First IN (SELECT Name FROM Table2) AND Table1.Last IN (SELECT Name FROM Table2) Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[tkleader]

Ken,

Thank you very much! It worked like a charm. Do you know of any website that teaches advance sql query.