FULL JOIN keyword is union of LEFT JOIN and RIGHT JOIN. It allows you to select values from both tables and returns everything from both when condition is met. Those values that are not going to meet criteria, will be replaced with NULL
Example
SELECT Customers.CustomerName, Orders.OrderIDFROM Customers FULL OUTER JOIN Orders ON Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;