What is the difference in an INNER JOIN and a FULL OUTER JOIN?

Full outer join is not a real thing in SOL

Full outer join returns tuples even if they do not have a matching tuple in the other relation

Full outer join requires union compatibility, where inner join does not

Full outer join returns tuples based on inequality, rather than equality