select 
    now.ITEM_CODE as CODE,
    COALESCE( hist.ITEM_NAME , "NULL" ) as NAME
from ITEM as now
LEFT join ITEM_HISTORY as hist
on now.ITEM_CODE = hist.ITEM_CODE
order by now.ITEM_CODE DESC;