>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

try

select * from test1 JOIN test2 on fld1 <= fld2