The SQL FULL JOIN syntax

The general syntax is:

1. SELECT column–names
2. FROM table–name1 FULL JOIN table–name2
3. ON column–name1 = column–name2
4. WHERE condition

The general FULL OUTER JOIN syntax is:

1. SELECT column–names
2. FROM table–name1 FULL OUTER JOIN table–name2
3. ON column–name1 = column–name2
4. WHERE condition

SQL FULL JOIN Examples

Problem: Match all customers and suppliers by country

1. SELECT C.FirstName, C.LastName, C.Country AS CustomerCountry,
2. S.Country AS SupplierCountry, S.CompanyName
3. FROM Customer C FULL JOIN Supplier S
4. ON C.Country = S.Country
5. ORDER BY C.Country, S.Country

This returns suppliers that have no customers in their country,
and customers that have no suppliers in their country,
and customers and suppliers that are from the same country.
Results: 195 records