OUUU thanks that works
you >all
>
>No need to use a table for temporary results. Copy the first part into a cursor:
>
>

>select ... into CURSOR Dup;
>  nofilter
>

>
>Now, select data from the main table, either with a subquery, or with a join. With a subquery:
>
>

>select * from MyTable;
>  where fname in (select fname from Dup);
>  into cursor Dup2
>