SQL FULL JOIN

The FULL JOIN returns all rows when there is a match in either the left or right table. If a row in the left table has no match in the right table, the result set includes the left row's data and NULL values for all columns of the right table. If a row in the right table has no match in the left table, the result set includes the right row's data and NULL values for all columns of the left table.

and

keyword is optional.

column_name(s)

table1

table2 ON table1.column_name = table2.column_name

condition

Below is a selection from the "Customers" table:

Obere Str. 57

12209

Avda. de la Constitución 2222 México D.F. 05021