SELECT 
 B.ITEM_CODE AS CODE
 C.ITEM_NAME AS NAME
 B.ORDER_QTY AS SUM_QTY
LEFT OUTER JOIN ORDERS B
 ON ITEM_CODE = B.ITEM_CODE 
FROM ORDERS_DTL A