SQL Joins - W3Schools

An SQL JOIN clause is used to combine rows from two or more tables, based on ... LEFT JOIN: Return all rows from the left table, and the matched rows from the ...

www.w3schools.com