FULLOUTERJOINOrdersONCustomers.CustomerID=Orders.CustomerID ORDERBYCustomers.CustomerName; Note:TheFULL OUTER JOINkeyword returns all the rows from the left table (Customers), and all the rows from the right ta
FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerName; Note: The FULL OUTER JOIN keyword returns all the rows from the left table (Customers), and all the rows from the right table (Orders). If there are rows in "Customers" that do not have matc...
Tip:FULL OUTER JOINandFULL JOINare the same. FULL OUTER JOIN Syntax SELECTcolumn_name(s) FROMtable1 FULLOUTERJOINtable2 ONtable1.column_name=table2.column_name WHEREcondition; Note:FULL OUTER JOINcan potentially return very large result-sets!