SELECT ITEM.ITEM_CODE as CODE, ITEM.ITEM_NAME as NAME, SUB.SUM_QTY
FROM ITEM
FULL OUTER JOIN (
SELECT ITEM_CODE, sum(ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL as dtl
LEFT JOIN ORDERS as s ON dtl.ORDER_NO = s.ORDER_NO
WHERE s.WH_CODE = 100
GROUP BY ITEM_CODE
) AS SUB
ON ITEM.ITEM_CODE = SUB.ITEM_CODE
WHERE SUM_QTY >= 50