Why to avoid FULL OUTER JOINS -- and what to use instead

Using FULL OUTER JOINS results in sloppy, inefficient SQL, with no true structure and NULLS in potentially every column in the results. Here's some better ways to write your SELECT if you think you might need to use a FULL OUTER JOIN.