what is the difference between a left join and a right join?
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.