Why is the basic difference between left join, right join and inner join?

Question Posted / deepti kapoor

1 Answers
1109 Views
I also Faced
E-Mail Answers

Why is the basic difference between left join, right join and inner join?..

Answer / Ravi Kant

In SQL (including MySQL), JOIN operations are used to combine rows from two or more tables based on a related column. The main differences between LEFT JOIN, RIGHT JOIN, and INNER JOIN lie in the handling of non-matching values: - An INNER JOIN returns only the matching rows from both tables (no nulls). - A LEFT JOIN includes all the rows from the left table and the matched rows from the right table. If there are no matches, it returns NULL on the right side. - A RIGHT JOIN includes all the rows from the right table and the matched rows from the left table. If there are no matches, it returns NULL on the left side.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer