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
pport]" Data: 08.02.2018 09:06
(GMT+01:00) Do: firebird-support@yahoogroups.com Temat: Re: [firebird-support]
Query problem
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
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,
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
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk
[firebird-support]" Data: 07.02.2018 22:24
(GMT+01:00) Do: fi