oracle8.1.6 select distinct crftd.path, crftd.storage_area_key from cr_files_to_delete crftd where not exists (select 1 from cr_revisions r where r.filename = crftd.path) SELECT count(*) FROM cr_revisions WHERE content = :name