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.