> At least it works on Sybase. A quick look at the ANSI standard gave me no > insight. Hmmm. Better safe than sorry. > Further changing "union" to "union all" will make it slightly more > efficient, because it will skip the step of eliminating duplicates. Good tip.