oracle8.1.6 select rule_name from rules where rule_id = :rule_id select persons.first_names || ' ' || persons.last_name as name, parties.email from persons, parties where person_id = :user_id and person_id = party_id