oracle8.1.6 select request_id, (select pretty_name from notification_types where notification_types.type_id = notification_requests.type_id) as type, decode ((select short_name from notification_types where notification_types.type_id = notification_requests.type_id), 'forums_forum_notif', (select name from forums_forums where forum_id = notification_requests.object_id), 'forums_message_notif', (select subject from forums_messages where message_id = notification_requests.object_id), '') as object_name, (select name from notification_intervals where notification_intervals.interval_id = notification_requests.interval_id) as interval, object_id from notification_requests where user_id = :user_id