Originally posted by TimHall

Note. Please don't start quoting examples of SQL with UNIONs. These are not examples of FULL OUTER JOINs, although they can be used to return the same data set that a FULL OUTER JOIN would.

Cheers
can u explain it in detail .