>>>Select Trans.cTrans_fk, Sum(Payments.yAmount_paid) as yAmount_paid, ; >>>Sum(Charges.yCharges_amount) as yCharges_amount ; >>>from Trans inner join Payments ; >>>on Trans.cTrans_pk = Payments.cTrans_fk ; >>>inner join Charges ; >>>on Trans.cTrans_pk = Charges.cTrans_fk ; >>>group by 1>>>
CREATE CURSOR crsTest (Fld1 I) CREATE CURSOR crsTest1 (Fld1 I) CREATE CURSOR crsTest2 (Fld1 I) INSERT INTO crsTest VALUES (1) INSERT INTO crsTest VALUES (2) INSERT INTO crsTest VALUES (3) INSERT INTO crsTest1 VALUES (1) INSERT INTO crsTest1 VALUES (3) INSERT INTO crsTest2 VALUES (2) SELECT * FROM crsTest; INNER JOIN crsTest1 ON crsTest.Fld1 = crsTest1.Fld1; INNER JOIN crsTest2 ON crsTest.Fld1 = crsTest2.Fld1 ** (no records in the query) SELECT * FROM crsTest; LEFT JOIN crsTest1 ON crsTest.Fld1 = crsTest1.Fld1; LEFT JOIN crsTest2 ON crsTest.Fld1 = crsTest2.Fld1 *** all records from crsTest with NULLs in other where there is no match