>>SELECT Fld1, SUM(Ammount) AS Ammount1; >> FROM crsTest1; >>GROUP BY Fld1; >>INTO CURSOR cTest1 >> >>SELECT Fld1, SUM(Ammount) AS Ammount2; >> FROM crsTest2; >>GROUP BY Fld1; >>INTO CURSOR cTest2 >> >>SELECT crsTest.Fld1,; >> cTest1.Ammount1,; >> cTest2.Ammount2; >>FROM crsTest; >>INNER JOIN cTest1 ON crsTest.Fld1 = cTest1.Fld1; >>INNER JOIN cTest2 ON crsTest.Fld1 = cTest2.Fld1 >>>