>What about

SELECT * FROM cursor1
>UNION
>SELECT * FROM cursor2
>

>BTW, I don't think you need ';' in the textmerge SQL SELECT.

select cTrans_pk, yBalance, cUserID, cUsGrLink_pk from cursor1
union
select cTrans_pk, yBalance, cUserID, cUsGrLink_pk from cursor2

would not work, since cUsGrLink_pk is going to be different.

; is removed in RunSQL function, but it helps if I want to test SQL separately.