Hello,
Can anyone have a look a the following ...
I have 2 entities: Customers and Orders
Customers and Orders are related via a CustomerId.
I want to select ALL customers,
EXCEPT those customers that have previously ordered a product with ProductId=x
I've tried something like:
select customers Where Order.ProductId != x
This seems to work, however, the customers who havent got any order yet, are not included, and I need those too!
Any help is appreciated!
Paul