Question: what is the difference between full outer join and full join?
Answer: The full outer join or full join returns all rows from both tables, matching up the rows wherever a match can be made and placing NULL s in the places where no matching row exists. It's true that some databases recognize the OUTER keyword. Some do not.