Sean,

I had to make some guesses, but try this:

SELECT supplier = ITM.poit_supplier,

local_orders = SUM(CASE WHEN ORD.pord_pondcode = 'Local' THEN ITM.poit_valord ELSE 0 END),

global_orders = SUM(CASE WHEN ORD.pord_pondcode <> 'Local' THEN ITM.poit_valord ELSE 0 END)

FROM poitem ITM

JOIN porder ORD

ON ORD.pord_order = ITM.poit_order

AND ORD.pord_supplier = ITM.poit_supplier

JOIN plsupp SUP

ON SUP.plsup_ndcode = ORD.pord_supndcode

WHERE ITM.poit_qtydel < ITM.poit_qtyord

GROUP BY

ITM.poit_supplier,

SUP.plsup_minord;

Paul