Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. use northwind
  2. select distinct a.CompanyName, a.Phone from customers as a
  3. except
  4. select distinct a.CompanyName, a.Phone
  5. from customers as a
  6. inner join orders b on b.customerID = a.customerID
  7. inner join [order details] c on b.orderid = c.orderid
  8. inner join products d on c.productid = d.productid
  9. inner join categories e on e.categoryID = d.CategoryID
  10. where CategoryName = 'Confections'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement