select apa.object_id,apa.profile_type,apa.profile_name,apa.role
from processace apa left join process p on apa.object_id = p.object_id and p.state=2 where apa.profile_type=5
and apa.object_id not in(
select distinct bb.object_id from processace bb left join process p on p.object_id=bb.object_id and p.state= 2 where bb.profile_type=3
)
from processace apa left join process p on apa.object_id = p.object_id and p.state=2 where apa.profile_type=5
and apa.object_id not in(
select distinct bb.object_id from processace bb left join process p on p.object_id=bb.object_id and p.state= 2 where bb.profile_type=3
)
select object_id,profile_type,profile_name,role
from
(
select apa.object_id,apa.profile_type,apa.profile_name,apa.role
from processace apa left join process p on apa.object_id = p.object_id and p.state=2
where apa.profile_type=5
)b
where b.object_id not in
(
select distinct bb.object_id from processace bb left join process p on p.object_id=bb.object_id and p.state= 2 where bb.profile_type=3
)select apa.object_id,apa.profile_type,apa.profile_name,apa.role
from processace apa left join process p on apa.object_id = p.object_id and p.state=2
where apa.profile_type=5=
select apa.object_id,apa.profile_type,apa.profile_name,apa.role
from processace apa where apa.profile_type=5
select distinct bb.object_id from processace bb left join process p on p.object_id=bb.object_id and p.state= 2 where bb.profile_type=3
=
select distinct bb.object_id from processace bb where bb.profile_type=3 结合起来
=
select object_id,profile_type,profile_name,role from processace where profile_type=5 and profile_type<>3=select object_id,profile_type,profile_name,role from processace where profile_type=5