outer join code example
Example 1: full outer join sql
SELECT C.FirstName, C.LastName, C.Country AS CustomerCountry, S.Country AS SupplierCountry, S.CompanyName FROM Customer C FULL JOIN Supplier S ON C.Country = S.Country ORDER BY C.Country, S.Country
Example 2: full join
All part of the tables both matching portions
and unmatching portions from both tables.