Query to select records in one table NOT in another

David Trowbridge · Jul 31, 2003

I have two tables, A and B. They have a common
field "email". I want to write a select query that lists
all the records in table B with email values that do NOT
appear in table A.

Suggestions?

Thank you very much.

David Trowbridge

David Trowbridge · Jul 31, 2003

Perfect!

Just what I needed.

Thanks, Arvi

-----Original Message-----
Hi

Select * From B Where email Not In (Select email From A)

Arvi Laanemets

.