outer join mysql code example Example: full join All part of the tables both matching portions and unmatching portions from both tables.