select
    i.item_code as code,
    CASE
        WHEN I.ITEM_NAME LIKE IH.ITEM_NAME || '%' THEN NULL
        ELSE I.ITEM_NAME
    END AS NAME
from
    item as i
left join
    item_history as ih
on
    i.item_code = ih.item_code
order by
    i.item_code desc