删除语句

[delphiprogramer]

要实现以下的删除功能
delete spcselecttemp from spcselecttemp a,spccharact b where a.fid=b.charactid
不能用in 和exists,怎么实现?急

[Drate]

什么不能用IN和？EXISTS？
你是说在DELETE语句中不能用这两个关键字吗？
呵呵，如果按你上面的语法写的话，删除的可是两个表的内容呀
delete spcselecttemp from spcselecttemp a,spccharact b where a.fid=b.charactid

-==>>
delete spcselecttemp from spcselecttemp where fid in (select charactid from spccharact);
or:
delete spcselecttemp from spcselecttemp where fid = (select charactid from spccharact);