LEFT JOIN

A LEFT JOIN returns every row from the left (first) table, plus matching rows from the right table. Where there is no match, the right table's columns come…