SQL query for left join

• Use the LEFT JOIN keyword to combine rows from two tables

• Specify the common column(s) using ON keyword

• Use SELECT statement to select the columns from both tables