Agoda Interview Question

Can you explain the difference between INNER JOIN and LEFT JOIN with an example?

Interview Answer

Anonymous

Apr 12, 2026

The inner join returns mutual rows of both tables. The left join returns all the rows from the left table, plus mutual rows of the right table