SELECT c.ContactName, o.OrderID FROM Customers c FULL OUTER JOIN Orders o ON c.CustomerID=o.CustomerID ORDER BY c.ContactName
Sunday, February 15, 2015
SQL: FULL OUTER JOIN
FULL OUTER JOIN is a join that returns all the results from the left hand side of the = sign and all the results of the right hand side.
For example this query returns all the customers and all the orders in one result
No comments:
Post a Comment