SQL LEFT JOIN

The LEFT JOIN returns all rows from the left table (table1), and only the matched rows from the right table (table2). If there is no match in the right table, the result for the columns from the right table will be NULL.

and

keyword is optional.

column_name(s)

table1

table2 ON table1.column_name = table2.column_name

Below is a selection from the "Customers" table:

Obere Str. 57

12209

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

Antonio Moreno Taquería

México D.F. 05023