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