JOINS and SET Operations — Question 3

Left join selects all data starting from the left table and matching rows in the right table.