View Single Post
  #5 (permalink)  
Old January 28th, 2008, 01:22 PM
Jeff Mason Jeff Mason is offline
Friend of Wrox
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post

Although, now that I think about it, the two alternatives aren't equivalent.

The UNION query would return one set of rows for the "left" side followed by another set for the "right".

The FULL OUTER JOIN would return essentially half as many rows, with either the "left" side values or "right" side values NULL depending on which didn't exist in their corresponding table.

Not quite the same thing...

Jeff Mason