SELECT *, SUM(AMT) AS TOTAMT FROM Orders GROUP BY OrdNbr>The table "Orders", unfortunately, contains both parent records and child records. This particular selection would give me one record for each OrdNbr and all of the original fields from "Orders", so that I would, in effect, be creating the parent records (with the fields for what should have been child records containing irrelevant information.)
* supposing OrdNbr,ChildRowNbr defines a record univocal SELECT Orders.*,TGROUP.TOTAMT; (SELECT OrdNbr,MAX(ChildRowNbr) ChildRowNbr,SUM(AMT) TOTAMT FROM Orders GROUP BY OrdNbr) TGROUP; JOIN Orders; ON Orders.OrdNbr=TGROUP.OrdNbr AND Orders.ChildRowNbr=TGROUP.ChildRowNbror
TRY SET EngineBehavior 70 SELECT *, SUM(AMT) AS TOTAMT FROM Orders GROUP BY OrdNbr FINALLY SET EngineBehavior 90 ENDTRY