哈，沒看清，你的也不對，try this

來源: 於 2004-12-15 19:50:42 [舊帖] [給我悄悄話] 本文已被閱讀：次

delete from occurrence
where not exists (
select *
from occurrence,page
where occurrence.page_id =page.page_id)