TCS interview question

Explain left join and right join in sql

Interview Answer

Anonymous

24 Jan 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.