怎样改写delete from select * from table解决方法

怎样改写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 ?