By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

querying all entries in one table that aren't in the other one

P: n/a
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?

Feb 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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));

Feb 14 '07 #2

P: n/a
<n.*******@gmail.comwrote
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?
Is there some particular reason that you cannot use the "Find Unmatched
Wizard" in the Query Builder? In the Query Tab of the DB Window, click New,
then one option will be the "Find Unmatched Wizard".

Larry Linson
Microsoft Access MVP
Feb 15 '07 #3

P: n/a

Thanks so much for all your help!

Apr 3 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.