原文链接:http://www.fengyachao.com/archives/65
delete from tableA a
where exists(select '1' from tableB b inner join tableC c on c.system_code=b.b001000 where c.class_code='ABAB' and c.level_code like '123123%' and b.class_type='ACAC' and a.tableB000=b.tableB000 and a.tableA505='LOVE' and a.state_id!='1')
要删除哪个表的数据,from后就跟哪个表,exists()后还可以再跟and进行条件限制