>hi all,
>i am having a bit of trouble remembering how to do this code. i have table 1 and cursor1 but i cannot get the 3rd line correct, have written it as i mean it to work.
>
>selcet * ;
> from table1 ;
> where table1.field1 is in cursor1.field2
> into cursor2 nofilter
>
>any help much appreciated.
>Slán
>~M

select * ;
   from table1 ;
     join cursor1 ;
       on table1.field1$cursor1.field2 ;
   into cursor2 nofilter

Tamar