Subject | Re[2]: [ib-support] sum(field) with subselect |
---|---|
Author | Roland Turcan |
Post date | 2002-09-07T15:04:29Z |
<<< 7. 9. 2002 17:00 - Helen Borrie "helebor@..." >>>
HB> table. Try
HB> select sum(t1.Field) from Table t1 where t1.ID in (select first 2 t2.ID
HB> from Table t2);
Thank you Helen, but this not solve my problem. IHMO this is problem
like "delete from Table where ID in (select first...), or not ?
--
Best regards, TRoland
http://www.rotursoft.sk
HB> table. Try
HB> select sum(t1.Field) from Table t1 where t1.ID in (select first 2 t2.ID
HB> from Table t2);
Thank you Helen, but this not solve my problem. IHMO this is problem
like "delete from Table where ID in (select first...), or not ?
--
Best regards, TRoland
http://www.rotursoft.sk