full outer join in mysql syntax code example

Example: full outer join in sql

FULL OUTER JOIN:
is used when retrieving data from
multiple tables and will return both
table records, matching and non-matching.