>hi,
>What are AreaCode and Team fileds ? numeric
>
>i'm sorry but still same message(SQL: Queries of this type are not supported (Error 1814))
>
>

> delete from table1 where recno() in (select rn from crsRand)
>

>
>thanks.

Well, that's too bad :( I hoped it would work. Since you do not have PK in table1, the other way is to do:

select crsRand
scan
   goto rn in Table1 && move record pointer to rn record in table1
   delete in Table1
endscan