Advertisement
Guest User

Untitled

a guest
Nov 29th, 2015
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT Customers.CompanyName, Customers.Phone
  2. FROM Categories
  3. INNER JOIN Products ON Products.CategoryID = Categories.CategoryID AND CategoryName = 'Confections'
  4. INNER JOIN [ORDER Details] ON [ORDER Details].ProductID = Products.ProductID
  5. INNER JOIN Orders ON Orders.OrderID = [ORDER Details].OrderID
  6. RIGHT OUTER JOIN Customers ON Orders.CustomerID = Customers.CustomerID
  7. WHERE Categories.CategoryID IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement