Question: what is difference between inner join and full join?
Answer: INNER JOIN - Returns only matched rows. FULL JOIN - Returns those rows that exist in the right table and not in the left, plus the rows that exist in the left table and not in the right, beyond the inner join rows.