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