create cursor test (fld c(4))insert into test values ('ABC') insert into test values ('CBA4') insert into test values ('BDC') insert into test values ('EG') insert into test values ('C22F') insert into test values ('2DB') insert into test values ('FE') insert into test values ('ADER') select fld as fld1 from test into cursor test1 select fld as fld2 from test into cursor test2 select * from test1,test2 into cursor mycursoron "Mycursor" you can see one row with fld1=ABC and fld2=BDC and another row with with fld1=BDC and fld2=ABC.