postgresql 7.2 SELECT p.customer_id, c.name as customer_name FROM pm_projectsx p LEFT JOIN organizations c ON p.customer_id = c.organization_id WHERE p.project_id = :original_project_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :original_project_id and ppm.privilege = 'read' and ppm.party_id = :user_id)