postgresql7.1 select p.party_id, acs_object__name(p.party_id) as name, p.email, '' as remove_url from wf_task_assignments ta, parties p where ta.task_id = :task_id and p.party_id = ta.party_id select distinct u.user_id, acs_object__name(u.user_id) as name, p.email from wf_task_assignments ta, party_approved_member_map m, parties p, users u where ta.task_id = :task_id and m.party_id = ta.party_id and p.party_id = m.member_id and u.user_id = p.party_id