怎样改写delete from select * from table
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 ?