这样:
DELETE TABLE1 where exists ( select 1 from table2 where and table1.khid=table2.khid and FWDWID=8);
或
DELETE TABLE1 where KHID in ( select KHID from table2 where FWDWID=8)
不可以这样:
DELETE TABLE1.*
FROM TABLE1,TABLE2 where TABLE1.KHID = TABLE2.KHID and TABLE2.FWDWID=8
DELETE TABLE1 where exists ( select 1 from table2 where and table1.khid=table2.khid and FWDWID=8);
或
DELETE TABLE1 where KHID in ( select KHID from table2 where FWDWID=8)
不可以这样:
DELETE TABLE1.*
FROM TABLE1,TABLE2 where TABLE1.KHID = TABLE2.KHID and TABLE2.FWDWID=8