Question: what is the difference between a left join and inner join?
Answer: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. ... The joined table will contain all records from both the tables and fill in NULLs for missing matches on either side.