A
Allan Skyner
I have a table "Suppliers" which has column "SupplierID", when I add products
the SupplierID is written to another table "Products". What I would like to
write is a query where the SupplierID IS in Suppliers but not in Products,
thus giving me a list of suppliers who do not have any products listed
against them.
Can anyone help, thanks in anticipation.
the SupplierID is written to another table "Products". What I would like to
write is a query where the SupplierID IS in Suppliers but not in Products,
thus giving me a list of suppliers who do not have any products listed
against them.
Can anyone help, thanks in anticipation.