View Single Post
  #3 (permalink)  
Old January 28th, 2008, 12:21 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
Default

A FULL OUTER JOIN would also work, and avoid the UNION operation.

Jeff Mason
je.mason@comcast.net