SELECT 
    it.item_code AS CODE,
    CASE
        WHEN it.item_name = ih.item_name THEN NULL
        ELSE it.item_name
    END AS NAME
FROM 
    item AS it
LEFT JOIN 
    item_history AS ih
ON 
    it.item_code = ih.item_code
    
order by it.item_code desc;