On Feb 14, 2:46 pm, n.berf...@gmail.com wrote:
Hi,
I have 2 tables linked to each other by a field. I'd like to query all
the enteries in one table that aren't in the other one, based on that
field. Any suggestions?
Here's an example...
Customers is the table that always has values (because you can't have
an invoice without a customer). Say I want to see any Customers
without Invoices.
SELECT Customers.CompanyName, Invoices.InvoiceID
FROM Customers LEFT JOIN Invoices ON Customers.CustomerID =
Invoices.CustomerID
WHERE (((Invoices.InvoiceID) Is Null));