Left Joins

The left join is a mechanism used to join tables before we add other conditions such as WHERE

SELECT
FROM
LEFT JOIN
ON Table1.column = Table2.column