>>>>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 >>>>>>>