oracle8.1.6 select u.email as user_email, id.email as id_email from cc_users u, ec_user_identification id where id.user_id = u.user_id(+) and id.user_identification_id=:user_identification_id select ec_action_id_sequence.nextval from dual