>SELECT  ;
>	ord.OrderID, ;
>	SUM( IIF(shp.ShipDate <  ldFromDate, shp.ShipAmt, 000000000.00)) AS ShipAmtBefore, ;
>	SUM( IIF(shp.ShipDate >= ldFromDate, shp.ShipAmt, 000000000.00)) AS ShipAmtAfter ;
>  FROM Order ord
>     JOIN Shipment shp ON ord.OrderID = shp.OrderID ;
>GROUP BY ord.OrderID		
>