View Single Post
  #3 (permalink)  
Old December 22nd, 2010, 05:19 AM
03jh01 03jh01 is offline
Registered User
 
Join Date: Dec 2010
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Thank you very much for the reply. It was very helpful!

And yes, would you mind giving an Access solution as well please, if only for my own future reference?

I also want to be able to find all Vendors that have only ever sold to New York , and nowhere else. I'm guessing it would be a similar query wouldn't it? It is basically just the opposite of finding Vendors that have NEVER sold to New York, isn't it?

Also, this part:

Code:
SELECT DISTINCT O.VendorID 
FROM Customers
Will that work if the Customers table doesn't have a VendorID field, as the Customers table doesn't have a VendorID?

Thank you very much once again :).

Last edited by 03jh01; December 22nd, 2010 at 01:27 PM..
Reply With Quote