>I have the following select that is acting wierd. It drops a record. The clihist table has two records that are identical. If I break this into two selects I get both records. As a union I only get one of the records.
>
>Any ideas on why this would happen? Does union have an implied DISTINCT statement?
>
Yes it does. You should use UNION ALL to get duplicates.
Edward Pikman
Independent Consultant