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

Leave a Reply

Your email address will not be published.