When should you use a LEFT JOIN in SQL?

When you want to retrieve all records from both tables
When you want to retrieve all records from the left table and matching records from the right table
When you want to retrieve only matching records from both tables
When you want to retrieve only records from the right table

A LEFT JOIN is used when you want to retrieve all records from the left table, regardless of whether there are matching records in the right table. It includes all records from the left table and the matching records from the right table. This is useful when you want to retrieve data from one table even if there are no corresponding records in the other table.

Add your answer