postgresql7.1
select p.party_id,
acs_object__name(p.party_id) as name,
case when p.email = '' then '' else '(' || p.email || ')' end as email
from parties p
where 0 < (select count(*)
from users u,
party_approved_member_map m
where m.party_id = p.party_id
and u.user_id = m.member_id)
select acs_object__name(party_id) as name
from parties
where party_id = :value
select p.party_id,
acs_object__name(p.party_id) as name,
case when p.email = '' then '' else '(' || p.email || ')' end as email
from parties p
where 0 < (select count(*)
from users u,
party_approved_member_map m
where m.party_id = p.party_id
and u.user_id = m.member_id)