On Wed, Nov 4, 2015 at 8:41 AM, 'checkmail' check_m...@satron.de [firebird-support] <firebird-support@yahoogroups.com> wrote:
> > > two tables > > > > A: > > Field1, Field2, Field3, Field4, Field5 > > > > B > > FieldA, FieldB, FieldC > > > > Now I would like to get the following: > > > > Sum(A.field3) where a.field1 = condition1 and a.field2 = condition2 > > In the same statement I would include > > Sum(b.fieldc) where b.fielda = a.field4 and b.fieldb = a.field5 > > > Without having tried it, I suggest: select sum (A.field3) from A where A.field1 = condition1 and A.field2 = condition2 UNION select sum (b.fieldc) from B inner join A where A.field1 = condition1 and A.field2 = condition2 and B.fielda = A.field4 and B.fieldb = A.field5 If A.field3 and B.fieldc are of different types you may need to cast them. Good luck, Ann >