Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 56 of 91

JOINS and SET Operations — Question 7

Back to all questions
7
Question

Question 7

How is a left join different from a natural join ?

Answer

In a LEFT JOIN, all rows from the left table are included along with matching rows from the right table, and NULL values are used for non-matching rows in the right table. Conversely, a natural join is a join where only one of the identical columns from the joined tables exists.