oracle 删除解决思路

oracle 删除
delete a from g_jianyxmdj a,r_jianyxmzl b where a.c_jianyxmbh=b.c_jianyxmbh

and b.j_jisgs is not NULL and c_jianydjbh= aa_jianydjbh
and (a.c_jianyxmzszx<0 or c_jianyxmzwzx is null);






这句话怎么错了？

[解决办法]

SQL code

delete from  a  where exists (select 1 from g_jianyxmdj a,r_jianyxmzl b where a.c_jianyxmbh=b.c_jianyxmbhand b.j_jisgs is not NULL and c_jianydjbh= aa_jianydjbhand (a.c_jianyxmzszx<0 or c_jianyxmzwzx is null));