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.