I think I'm missing something. Do you want to have only one duplicate record from both cursors or you want to add only one duplicate record from the second cursor crreating possible duplicates in the result set?
>I tried UNION but it removed both duplicates.
>
>>>I have two selects all structurally identical. I want to merge the two selects, and any duplicate records, I want 1 kept not both removed.
>>
>>UNION ALL will keep all records, UNION - only one of the duplicate records. The key is the whole record.
--sb--