Exam4Training

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

Answer: A

Explanation:

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

Exit mobile version