pcsoft.us.windevCopyright 2026, PC SOFT15 Apr 2016 14:57:00 Z12 Apr 2016 14:50:00 ZI can't find out what's wrong with below query. It work ONLY in test mode with checked option: "Run query without hQueryWithOutCorrection in test mode" In app I get an error: "Aktivnost alias already used" (I do not use aliases) Files are local HFSQLC/S. I checked every subquery one at time, and all worked as expected. Does somebody have an idea? Is it allowed to use subquery inside subquery? (It work in some other cases) SELECT Clan.ClanID AS ClanID, Oznaka.Oznaka AS Oznaka_Oz, Clan.Broj AS Broj, Clan.Prezime AS Prezime, Clan.Ime AS Ime, Titula.Naziv AS Naziv, Spol.Spol AS Spol, Clan.Adresa AS Adresa, Mjesto.PTT AS PTT, Mjesto.NazivMjesta AS NazivMjesta, Clan.StatusTip AS StatusTip, Clan.StatusDatumOD AS StatusDatumOD, Clan.StatusDatumDO AS StatusDatumDO, AktivnostUpit.sum_Bodovi, AktivnostUpit.sum_BodoviRegulativa, AktivnostUpit.sum_BodoviOpcenito, StatusNaDan.StatusTip AS StatusTipAktualni, StatusNaDan.Datum AS Datum FROM Clan LEFT OUTER JOIN Oznaka ON Clan.OznakaID = Oznaka.OznakaID LEFT OUTER JOIN Mjesto ON Clan.MjestoID = Mjesto.MjestoID LEFT OUTER JOIN Titula ON Clan.TitulaID = Titula.TitulaID LEFT OUTER JOIN Spol ON Clan.SpolID = Spol.SpolID LEFT OUTER JOIN ( SELECT StatusNaDan.ClanID AS ClanID, StatusNaDan.StatusTip AS StatusTip, StatusNaDan.Datum AS Datum FROM Status AS StatusNaDan INNER JOIN ( SELECT Status.ClanID AS ClanID, MAX(Status.Datum) AS maximum_Datum FROM Status WHERE Status.Datum BETWEEN {paramDatumOD} AND {paramDatumDO} GROUP BY Status.ClanID ) AS StatusMaxDate ON StatusNaDan.ClanID = StatusMaxDate.ClanID WHERE StatusNaDan.Datum = StatusMaxDate.maximum_Datum ) AS StatusNaDan ON Clan.ClanID = StatusNaDan.ClanID LEFT OUTER JOIN ( SELECT Aktivnost.ClanID, SUM(Aktivnost.Bodovi) AS sum_Bodovi, SUM(Aktivnost.BodoviRegulativa) AS sum_BodoviRegulativa, SUM(Aktivnost.BodoviOpcenito) AS sum_BodoviOpcenito FROM Aktivnost WHERE Aktivnost.Datum BETWEEN {paramDatumOD} AND {paramDatumDO} GROUP BY Aktivnost.ClanID ) AS AktivnostUpit ON Clan.ClanID = AktivnostUpit.ClanID ORDER BY Clan.Prezime, Clan.Ime30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57314/read.awp15 Apr 2016 14:57:00 ZI put the cleaned project here: http://et35.square7.ch/public/Backup_eKomora_2016-04-15.ZIP So if someone is willing to lo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57314/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57314/read.awpWD18 Queries, Subqueries, Problems... Help pleaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57313/read.awp15 Apr 2016 13:32:00 ZHi, I would re-factor/simplify your nested SQL so that you can prove if nesting to the level you are trying is possible. Then…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57313/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57313/read.awpWD18 Queries, Subqueries, Problems... Help pleaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57310/read.awp15 Apr 2016 12:47:00 ZHi, Maybe the fat that you are using a sum several times In the first select and later on : SUM(Aktivnost.Bodovi Regar…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57310/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57310/read.awpWD18 Queries, Subqueries, Problems... Help pleaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57275/read.awp12 Apr 2016 21:13:00 ZHi DarrenF, Peter, Thanks for reply, I do not use HAlias() at all. I did try many combinations, with and without AS keyword…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57275/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57275/read.awpWD18 Queries, Subqueries, Problems... Help pleaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57271/read.awp12 Apr 2016 17:06:00 ZHi Marijan, Do you also execute your query in your app with the hQueryWithoutCorrection option? Cheers, Peter H.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57271/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57271/read.awpWD18 Queries, Subqueries, Problems... Help pleaseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57270/read.awp12 Apr 2016 16:00:00 ZHi Marijan, There are alias's all over the SQL code you supplied (after the AS keyword), but I can't see from the SQL where y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57270/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57267-wd18-queries-subqueries-problems-help-please-57270/read.awpWD18 Queries, Subqueries, Problems... Help please