Exclude any that match

[WithoutPause]

What I want to select is the sales rep name that doesn't have any orders with a specific customer.

Sales Rep
ID
Name



Customer
ID
Name
etc info

Order
ID
Sales_rep_id
Cust_id
etc..

In this case I want the sales rep name that doesn't have any orders with customer "Bob." Initial pass eliminated including any order with Bob but it still returned the sales rep's name, ie if sales rep Steve had an order with Bob and Jack, his name was included. What I want is for Steve not to be included since he does have an order with Bob. I'm wondering if I should use something like IN or EXIST, or if there is another approach that would work.

[June7]

Try:

SELECT * FROM [Sales Rep] WHERE ID NOT IN (SELECT Sales_rep_id FROM Order WHERE Cust_id=[enter id here]);