不用subquery 的解決方法, 如果

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

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