Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use northwind
- select distinct a.CompanyName, a.Phone from customers as a
- except
- select distinct a.CompanyName, a.Phone
- from customers as a
- inner join orders b on b.customerID = a.customerID
- inner join [order details] c on b.orderid = c.orderid
- inner join products d on c.productid = d.productid
- inner join categories e on e.categoryID = d.CategoryID
- where CategoryName = 'Confections'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement