-
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 New York. How do I do this? I just cannot get my head around it.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|