Question: what is the difference between left join and right join?
Answer: LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table. FULL JOIN: It combines the results of both left and right outer joins.