TCS Interview Question
Explain left join and right join in sql
Interview Answer
Anonymous
Jan 24, 2026
LEFT JOIN returns all records from the left table and matching records from the right, whereas RIGHT JOIN returns all records from the right table and matching records from the left.