Not in Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of Suppliers that gets downloaded each month, New suppliers
are added each month and I want to design a query that will extract all new
suppliers from the list.

The following table holds supplier details which was downloaded last month:
tblSupplier(SuppID, SuppName, Address, Tel)

The following table holds all the info for suppliers downloaded this month
tblTEMPImport(SuppID, SuppName, Address, Tel)

I can use a query to show suppliers which appear on both lists but I cannot
seem to find a way to show suppliers which are in tblTEMPimport but not in
tblSuppliers.

Can anyone help?

Many thanks
 
Dear Edgar:

SELECT T.*
FROM tblTEMPImport T
LEFT JOIN tblSupplier S ON S.SuppID = T.SuppID
WHERE S.SuppID IS NULL

This should show all the "new" suppliers in the import table, based on
their SuppID numbers. Is this the correct way to define which are
new?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Tom - thanks for the response, yes this is the correct way to define new
suppliers and it worked.
 
Back
Top