View Single Post
  #1 (permalink)  
Old December 21st, 2010, 07:21 PM
03jh01 03jh01 is offline
Registered User
 
Join Date: Dec 2010
Posts: 5
Thanks: 7
Thanked 0 Times in 0 Posts
Default Finding who doesn't sell to a certain place...

Hi all,

I have a Vendor table which links to an Order table via VendorID. I have a Customer table that also links to the Order table via CustomerID.

This means the order table provides a list of all orders, and the IDs of the Customers who made the orders, and the Vendors who handled the orders. For a given order, I can find the State that the customer is from (using Customer table's State field).

This means I can get where the Vendor's sell too. I need to use a sql query to produce a list of vendor's that have NEVER sold to a customer in New York. How do I do this? I just cannot get my head around it.

Thanks.

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