LEFT JOIN

A LEFT JOIN returns all rows from the left table (the table listed before the LEFT JOIN keyword) and the matching rows from the right table (the table listed after the LEFT JOIN keyword). If there is no match in the right table for a row in the left table, the result will contain NULL values for the columns from the right table. Effectively, it ensures all rows from the left table are included in the result set, regardless of whether there's a corresponding row in the right table.