delete from  a  where exists (select 1 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));