Which join keeps every row of the left table, even when nothing matches on the right?
LEFT JOINCROSS JOINRIGHT JOININNER JOIN
A
Play SQL & Databases ▸
LEFT JOIN returns all left rows and fills the right-side columns with NULL when there is no match.