Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Customers.CompanyName, Customers.Phone
- FROM Categories
- INNER JOIN Products ON Products.CategoryID = Categories.CategoryID AND CategoryName = 'Confections'
- INNER JOIN [ORDER Details] ON [ORDER Details].ProductID = Products.ProductID
- INNER JOIN Orders ON Orders.OrderID = [ORDER Details].OrderID
- RIGHT OUTER JOIN Customers ON Orders.CustomerID = Customers.CustomerID
- WHERE Categories.CategoryID IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement