SQL FULL OUTER JOIN Keyword

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL FULL OUTER JOIN Keyword


❮ SQL Keywords Reference


FULL OUTER JOIN


The FULL OUTER JOIN command returns all rows
when there is a match in either left table or right table.


The following SQL statement selects all customers, and all orders:




SELECT Customers.CustomerName, Orders.OrderID

FROM Customers

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 matches in "Orders", or if there
are rows in "Orders" that do not have matches in "Customers", those rows will be
listed as well.



❮ SQL Keywords Reference


-