SELECT Header.*, ; ROUND(SUM(IIF(ChildCondition1,Child.Qty,0)),2) AS Qty1, ; ROUND(SUM(IIF(ChildCondition2,Child.Qty,0)),2) AS Qty2, ; ROUND(SUM(IIF(ChildCondition3,Child.Qty,0)),2) AS Qty3 ; FROM Header ; JOIN Child ON Header.HeaderID = Child.HeaderID