>
>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.
I think you meant UNION ALL is NOT supposed to eliminate dupes :) Thanks for the heads-up.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up