MySQL does not really support a FULL OUTER JOIN but you can create one with both a LEFT and RIGHT Outer Join
Some SQL Languages do support a FULL Outer Join (Like Postgre SQL as shown in the video coming up soon)
Like SQL PostgreSQL is Open Source
https://stackoverflow.com/questions/3362079/is-there-a-reason-mysql-doesnt-support-full-outer-joins