with ta as (
select ITEM_CODE, ITEM_NAME as ITEM_NAME_H
from ITEM_HISTORY)

select ITEM_CODE as CODE,
case when ITEM_NAME = ITEM_NAME_H then null else ITEM_NAME end as NAME
from ITEM
left join ta
using (ITEM_CODE)
order by ITEM_CODE desc