SELECT
i.ITEM_CODE AS CODE,
CASE
WHEN h.ITEM_NAME IS NULL THEN i.ITEM_NAME
WHEN i.ITEM_NAME <> h.ITEM_NAME THEN i.ITEM_NAME
ELSE NULL
END AS NAME
FROM
ITEM i
LEFT JOIN
ITEM_HISTORY h
ON
i.ITEM_CODE = h.ITEM_CODE
ORDER BY
i.ITEM_CODE DESC;