>Don't know if it's relevant, but by default UNION deletes duplicate rows. So, if some of the 38 are dupes that might account for it.

Al,

Just an FYI - specifying UNION ALL (as in his original snippet) is supposed to eliminate duplicate rows from the result set.

Laterness,
Jon