Question: When would you use a left join query?

1. When you want to retrieve every record from the left table, plus any matching information from the right table where it exists
2. When you want to retrieve all of the records from the right table that have matching records in the left table
3. When you want to retrieve just the records from the left table that have matching records in the right table
4. When you want to retrieve just the records from the left table that do not have any matching records in the right table

Answer: The correct answer of the above question is Option A:When you want to retrieve every record from the left table, plus any matching information from the right table where it exists