Select that is not in a table

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

Can someone give me an idea on how to handle this.
I have 2 tables one has all data and one that i have code
for defective.

What i need is select only records that the codes is not
in that table.

Any ideas is appreciated.

Thanks
Vina
 
Can someone give me an idea on how to handle this.
I have 2 tables one has all data and one that i have code
for defective.

What i need is select only records that the codes is not
in that table.
Click to expand...

Use the "Unmatched Query Wizard" to find all records in Table1 that
have no matching record in Table2.
 
Back
Top