oracle8.1.6 select * from ( select cpr.man_id, cpr.res_id, 'delivery' as needscorte from ims_cp_resources cpr where cpr.man_id = :man_id order by cpr.scorm_type desc) where rownum = 1 select * from ( select v.last_viewed from views_views v, ims_cp_items i, ims_cp_organizations o where v.viewer_id = :user_id and v.object_id = i.ims_item_id and i.org_id = o.org_id and o.man_id = :man_id order by v.last_viewed desc) where rownum = 1