1
2SELECT Customers.CustomerName, Orders.OrderID
3
4FROM Customers
5
6FULL OUTER JOIN Orders
7ON Customers.CustomerID=Orders.CustomerID
8
9ORDER BY Customers.CustomerName;
10
1123SELECT columns FROM table_A FULL OUTER JOIN table_B ON join_conditionsXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
1FULL OUTER JOIN:
2is used when retrieving data from
3multiple tables and will return both
4table records, matching and non-matching.