不用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