oracle8.1.6 select v.area_id, v.name, v.full_name, v.user_id, decode(a.user_id, null, 0, 1) as already_assigned_p from ttl_area_assignments a, (select ta.area_id, ta.name, p.first_names || ' ' || p.last_name as full_name, tu.user_id from ttl_va_areas ta, ttl_v_users tu, persons p where ta.context_id = :package_id and tu.package_id = :package_id and tu.user_id = p.person_id) v where v.area_id = a.area_id(+) and v.user_id = a.user_id(+) order by v.name, v.full_name