>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.
If it's not broken, fix it until it is.
My Blog