SELECT
    it.ITEM_CODE AS CODE,
    CASE it.ITEM_NAME
        WHEN ith.ITEM_NAME THEN 'NULL'
        ELSE it.ITEM_NAME
    END AS NAME
FROM ITEM it
 INNER JOIN ITEM_HISTORY ith
  ON it.ITEM_CODE = ith.ITEM_CODE
ORDER BY it.ITEM_CODE desc