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));