不用subquery 的解决方法, 如果

ANSI SQL standard is supported.


delete occurrence
from occurrence left join page on occurrence.page_id = page.page_id
where page.page_id is null

所有跟帖： 

• 嗯大师这招好使 -Epimetheus- ♂ (0 bytes) () 12/15/2004 postreply 20:26:14

• 回复：mysql 里autoincrement 的int 太 -bbllot- ♀ (88 bytes) () 12/15/2004 postreply 20:31:13

• lookup in the manual -SQL大师- ♀ (0 bytes) () 12/15/2004 postreply 20:42:05