oracle sql exists 用法

SELECT house.id,       house.resblock_name,       house.building_name,       house.unit_name,       house.room_no,       house.house_name,       house.house_code  FROM hdic.t_hm_house house where house.city_id = '110000'         AND not exists (select 1          from hdic.t_hm_build_panorama pan         where house.id = pan.build_id           and pan.build_type = 2           and pan.upload_status = 1)