left outer join

SQL LEFT JOIN

SQL LEFT JOIN or LEFT OUTER JOIN returns all rows from the left table and the matching rows from the right table.

A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.