oracle8.1.6 select email, first_names || ' ' || last_name as name from parties, ($sql_query) p2, persons where parties.party_id = person_id(+) and p2.party_id = parties.party_id