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

Query unlisted tasks

P: 2
I have a list table which lists all possible products a vendor could purchase.

another table that list all products a vendor has purchased.

I want a query that will tell me which products a vendor has never purchased.
May 21 '07 #1
Share this Question
Share on Google+
3 Replies

Rabbit
Expert Mod 10K+
P: 12,441
There is a Find Unmatched Query Wizard that you can use.
May 21 '07 #2

P: 2
There is a Find Unmatched Query Wizard that you can use.
I tried that but when i try to narrow the seach to one specific vendor i get an error
May 22 '07 #3

Rabbit
Expert Mod 10K+
P: 12,441
I tried that but when i try to narrow the seach to one specific vendor i get an error
Can you describe this error?

Posting the SQL and Metadata about the tables would help.
May 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.