Hi
Your bolded subquery need to have value e.g. VAREPLU_ID but you not group by
this field and server do not know its value then
If I understand that correct, I should do something like this:
SELECT
VARER.PLU_NR,
VAREFRVSTR_DETAIL.V509INDEX,
Sum(VAREFRVSTR_DETAIL.ANTALSTK) AS AntalStk,
Hi,
Yes, but source of one column is ommitedVAREFRVSTR_DETAIL.LAENGDE_NAVNYou
group by VAREFRVSTR.LAENGDE_NAVN
Change your group by or change source of column in subquery
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk
[firebird-support]" Da
Thank you.
Now I understand and now it works.
Like this:
SELECT
VARER.PLU_NR,
VAREFRVSTR_DETAIL.V509INDEX,
Sum(VAREFRVSTR_DETAIL.ANTALSTK) AS AntalStk,
(SELECT
Sum(TRANSAKTIONER.SALGSTK)
FROM
TRANSAKTIONER
WHERE
TRANSAKTIONER.ART IN (0, 1) AND
TRANSAKTION
Hello,
This query was known to work in Firebird 3.0.2 :
select
2 as TYPE_MVT,
TYPE_REGLEMENT,
DEVISE,
null as BANQUE
sum(QUANTITE) as NOMBRE,
sum(VALEUR) as MONTANT
from JOURNAL_CAISSE
where (TYPE_MOUVEMENT in (2, 3)) and (ANNULE is false)
and (periode = ?)
group by 1,2,3,4
Now,, i
> Is it as expected ?
No, please register it at tracker.
Regards,
Vlad
Done : http://tracker.firebirdsql.org/browse/CORE-5743
On Thu, Feb 8, 2018 at 5:46 PM, hv...@users.sourceforge.net
[firebird-support] wrote:
>
>
> > Is it as expected ?
>
> No, please register it at tracker.
>
> Regards,
> Vlad
>
>
>