Hi,
Help please,

I have cursor (name is mycursor) with two fields .
Example:

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 mycursor

on "Mycursor" you can see one row with fld1=ABC and fld2=BDC and another row with with fld1=BDC and fld2=ABC.
How can I void it? (it is not important form me what to omit).

sorry for my poor english
Tnx