Why is the basic difference between left join, right join and inner join?
- 1 Answers
- 1110 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
