A full outer join returns code example

Example: Full outer join example

SELECT Customers.CustomerName, Orders.OrderID

FROM Customers

FULL OUTER JOIN Orders
ON Customers.CustomerID=Orders.CustomerID

ORDER BY Customers.CustomerName;