oracle8.1.6 select i.content_type, i.name, nvl(r.title, i.name) title, i.latest_revision from cr_items i, cr_revisions r where i.item_id = :item_id and i.latest_revision = r.revision_id (+)