oracle8.1.6 SELECT (sn.im_screen_name) as screen FROM jb_screens sn WHERE sn.user_id = :user_id_friend AND sn.service = :trans_symbol select first_names , last_name from persons where person_id =:user_id Select (sn.im_screen_name) as screen, (sn.user_id) as cur from jb_screens sn WHERE (sn.user_id = :user_id or sn.user_id = :user_id_friend) AND sn.service = 'jabber'