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

Query Questioin

P: n/a
I have two tables that has the following:

Table #1
AuctionDate
BidderNumber
FirstName
LastName
TaxExempt

Table #2
AuctionDate
BidderNumber
PaymentMethod
PaymentNumber
Amount

I want to have a query tell me which bidders are in table #1 are NOT in
Table#2. Anyone have any ideas as to how to do this? I cant seem to
figure it out.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On the database window, click the Queries tab, then click the New Button,
and in the dialog that pops up, select "Find Unmatched Query Wizard".

That should do what you want. And, not only that, you can look at what it
generated just in case you want to do it without the Wizard next time, or
want to modify it.

Larry Linson
Microsoft Access MVP
"Nothing" <me@you.com> wrote in message
news:3f*********************@news.frii.net...
I have two tables that has the following:

Table #1
AuctionDate
BidderNumber
FirstName
LastName
TaxExempt

Table #2
AuctionDate
BidderNumber
PaymentMethod
PaymentNumber
Amount

I want to have a query tell me which bidders are in table #1 are NOT in
Table#2. Anyone have any ideas as to how to do this? I cant seem to
figure it out.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

P: n/a
Nothing <me@you.com> wrote in message news:<3f*********************@news.frii.net>...
I have two tables that has the following:

Records in table1 that are not in table2.

SELECT *
FROM Table1 LEFT JOIN Table2 ON Table1.BidderNumber=Table2.BidderNumber
WHERE Table2.BidderNumber IS NULL;
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.