No Full Outer Joins in MySQL - how to simulate if you want them

http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-join-in-mysql/

How to simulate FULL OUTER JOIN in MySQL

http://stackoverflow.com/questions/2384298/mysql-full-outer-join-syntax-error

http://stackoverflow.com/questions/4796872/full-outer-join-in-mysql