Question: what is the difference between right and left 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. ... The joined table will contain all records from both the tables and fill in NULLs for missing matches on either side.