>>>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.Yes, that's what I read in the help:
[UNION [ALL] SELECTCommand]
Combines the final results of one SELECT with the final results of another SELECT. By default, UNION checks the combined results and eliminates duplicate rows. Use parentheses to combine multiple UNION clauses.
ALL prevents UNION from eliminating duplicate rows from the combined results.Hmmmm.... maybe I need some parentheses?
Randy Bosma
VFP - Because life is too short to code in something else...
