delete A from A left join B on B.b=A.a where B.c='';
delete a from a left join b on b.b=a.a where b.c=''
有點看不動,可以舉例說明下。tks
delete a from a left join b on b.b=a.a where b.c=''这个也不行耶
delete A from (A left join B on B.b=A.a) where B.c=''====================1.如果delete后面的那个A是字段名还是你想作用的表名? 暂且按表名处理delete A.a from A where A.a in ( select A.a from A left join B on A.a = B.b where B.c = '')
delete A
from B
where B.b=A.a and B.c=''
不行耶
left join B
on B.b=A.a where B.c='';
暂且按表名处理delete A.a from A where A.a in
( select A.a from A left join B on A.a = B.b where B.c = '')