🚀 go-pugleaf

Hi,

> select a.o_csoc, a.o_nreserc, a.o_conto, a.o_sezio, a.o_curcytot,
>  a.o_curcynaz,   max(a.o_percam),
>  sum(a.o_prnzdr) - sum(a.o_prnzav) Sdo_Naz,
>  sum(a.o_prexdr), sum(a.o_prexav),
>  sum(a.o_prnzdr), sum(a.o_prnzav),
>  (select b1.nicknm from sezio b1 where b1.csoc = a.o_csoc and
>   b1.nreserc = a.o_nreserc  and b1.csez = a.o_sezio and
>   b1.fdel = '0' ) as DescrSezio
>  from SDICOGE (:csoc ,: abinp , :fil , :lastdata , :allambfil ) a
>  group by  a.o_csoc, a.o_nreserc, a.o_conto, a.o_sezio,
>            a.o_curcytot, a.o_curcynaz
>  order by  a.o_csoc, a.o_nreserc, a.o_conto, a.o_sezio, a.o_curcytot
>
> If I remove sum fields and group by clause query works.
> If I remove subquery , query works.
>
> Which is the conflict ?

Your query looks fine, but for some reason InterBase seems not to be able to handle it.
There are some workarounds you can try
- put an aggregate function around the sub-select (MIN / MAX)
- put an aggregate function around b1.nicknm (MIN / MAX)
- move the sub-select into the from clause as an LEFT JOIN and group on b1.nicknm too

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database with many powerful SQL features:
  http://www.firebirdsql.org
  http://www.firebirdsql.info

General database developer support:
  http://www.databasedevelopmentforum.com

Support list for Interbase and Firebird users:
  firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
  news://newsgroups.firebirdsql.info