delete from select * from table
这样写无法执行,请问怎样改写.
------解决方案--------------------
delete table where ?? not in (select ?? from table))
delete table where ?? in (select ?? from table))
------解决方案--------------------
delete a from a, b where ???
------解决方案--------------------
delete from a where ?