select
    i.item_code as code,
    case
        when 
        i.item_name = 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
where
    i.item_name <> "フリルブラウスRockNew" 
order by
    i.item_code desc