SQL LEFT JOIN Keyword - W3Schools

The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is ... SQL LEFT JOIN Syntax.

www.w3schools.com