>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
delete in Table1
endscan
If it's not broken, fix it until it is.
My Blog