Question: what is the difference between left join and full join?
Answer: Left Outer Join: Returns all the rows from the LEFT table and matching records between both the tables. Right Outer Join: Returns all the rows from the RIGHT table and matching records between both the tables. Full Outer Join: It combines the result of the Left Outer Join and Right Outer Join.