Posted by: Pdfprep
Post Date: January 31, 2021
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