select count(*),cc.connector_id
from connector cc, device de
where de.device_id = cc.device_id(+)
and de.status = 'U'
and cc.maint_sts = 'N'
and de.res_spec_id = 201502
group by cc.connector_id
having count(*)>1
保持红字部分相同 蓝色部分可有可无 如果查询结果产生多个红字部分字段则产生笛卡尔积
(相当于两集合做X乘操作)