True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table
A . True
B . False

View Answer

Answer: A

Explanation:

This is true, indeed!

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

Reference: https://www.w3schools.com/sql/sql_join_left.asp