If there are duplicate rows and you want to keep them you
should use UNION ALL instead of just using UNION.


>>Select all the records from 2 cursors and put them into 1 cursor?
>
>Use the UNION feature:
>
>SELECT name,descriptio FROM address ;
> WHERE Groupid=lcShippergroup ;
>UNION ;
>SELECT name,descriptio FROM address ;
> WHERE Code = Policy.Id ;
> INTO Ultimate Result
>
>The corresponding fields must have the same type and size.
>
>Tamar