哈，没看清，你的也不对，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)