快乐编程

[sql]
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’
)
[/sql]
要删除哪个表的数据，from后就跟哪个表，exists()后还可以再跟and进行条件限制