试试这个

来源: 2004-12-15 19:23:06 [旧帖] [给我悄悄话] 本文已被阅读:

delete occurrence from
occurrence ,page
where occurrence.page_id = page.page_id