Using a table field as criteria in a query

[aaron_brown_GC]

I have a table of customer reservations, and a table of customer id's and names. I want to eliminate all of the customer records in table number 1 that match the customer names in table #2.

Is this a simple query? If so, how do I proceed?

ASAP help please!

 

[araskas]

It is a simple query. Use In clause as below-

SELECT Table1.*
FROM Table1
Where Cid not in ( SELECT Cid from Table2 );

 

[aaron_brown_GC]

And input this information in the criteria field of the query design window?

 

[araskas]

In the query woindow goto SQL view ( use View- SQL View ) . Then paste this text into the SQL view window

 

[aaron_brown_GC]

Thank you! Thank you!

You just saved my department about
a week of manual work sorting through
these records!

Aaron