pcsoft.us.windevCopyright 2026, PC SOFT30 May 2017 13:10:00 Z22 May 2017 10:54:00 ZHi, for test I have converted a WD19-project to WD22 and now there's a funny warning in a query that I do not understand ( Warning : The item of the join condition <( TblRelatieVoerlev.TblRelatieID = FileFlock.KeyRelationID_Voerleverancier )> does not affect the joined tables. QRY_Select_EdkKoppels_voorPlanningVB, SQL Code, line 29, column 96) but inWD19 this query has no warning and runs fine: SELECT TblEdkKoppel.TblEdkKoppelID AS TblEdkKoppelID, TblEdkKoppel.Aantaldieren AS Aantaldieren, TblEdkKoppel.aantalGeleverd AS aantalGeleverd, TblEdkKoppel.Opzetdatum AS Opzetdatum, TblEdkKoppel.tblHokID AS tblHokID, TblEdkKoppel.tblRasID AS tblRasID, TblEdkKoppel.tblRelatieID_Voerleverancier AS tblRelatieID_Voerleverancier, TblEdkKoppel.TblrelatieID_vleeskuikenhouder AS TblrelatieID_vleeskuikenhouder, TblEdkKoppel.TblRelatieID_afnemer AS TblRelatieID_afnemer, TblHok.tblHokCode AS tblHokCode, TblRas.Rascode AS Rascode, TblRelatie.Bedrijfsnaam AS Vleeskuikenhouder, TblRelatieIntegratie.Bedrijfsnaam AS Integratie, TblRelatieVoerlev.Bedrijfsnaam AS Voerleverancier, TblEdkKoppel.voorbroed AS voorbroed, TblEdkKoppel.Hatchcare AS Hatchcare, TblEdkKoppel.plus4 AS plus4, TblEdkKoppel.TblArtikelID_enting AS TblArtikelID_enting, TblEdkKoppel.leverdatum AS leverdatum, TblEdkInleg.CodeFlockCD AS CodeFlockCD, CASE WHEN TblEdkInleg.CodeFlockCD IS NULL THEN 1 ELSE 0 END AS NietGepland, FileFlock.dateFlockStartDateBirth AS dateFlockStartDateBirth FROM TblEdkKoppel LEFT OUTER JOIN TblHok ON TblHok.tblHokID = TblEdkKoppel.tblHokID LEFT OUTER JOIN TblRas ON TblRas.tblRasID = TblEdkKoppel.tblRasID LEFT OUTER JOIN TblRelatie ON TblRelatie.TblRelatieID = TblEdkKoppel.TblrelatieID_vleeskuikenhouder LEFT OUTER JOIN TblRelatie AS TblRelatieIntegratie ON TblRelatieIntegratie.TblRelatieID = TblEdkKoppel.TblRelatieID_afnemer LEFT OUTER JOIN TblRelatie AS TblRelatieVoerlev ON TblRelatieVoerlev.TblRelatieID = FileFlock.KeyRelationID_Voerleverancier // <= Here I get the warning! LEFT OUTER JOIN FileFlock ON TblEdkInleg.CodeFlockCD = FileFlock.CodeFlockCD LEFT OUTER JOIN TblEdkInleg ON TblEdkKoppel.TblEdkKoppelID = TblEdkInleg.TblEdkKoppelID WHERE ( TblEdkKoppel.Opzetdatum BETWEEN {pdBegindatum} AND {pdEinddatum} AND TblEdkKoppel.TblrelatieID_vleeskuikenhouder = {piVleeskuikenhouderID} AND TblEdkKoppel.TblrelatieID_vleeskuikenhouder IN ({psListRelatieID_Vleeskuikenhouder}) AND TblEdkKoppel.TblRelatieID_afnemer = {piRelatieID_Afnemer} AND TblEdkKoppel.TblRelatieID_afnemer IN ({psListRelatieID_Afnemer}) AND TblEdkKoppel.tblRelatieID_Voerleverancier = {piRelatieID_Voerleverancier} AND TblEdkKoppel.tblRelatieID_Voerleverancier IN ({psListRelatieID_Voerleverancier}) AND TblEdkKoppel.tblRasID = {piRasID} AND TblEdkKoppel.leverdatum BETWEEN {pdBeginLeverdatum} AND {pdEindLeverdatum} AND (NietGepland = 1 OR TblEdkInleg.Afdrukken = 1) ) ORDER BY NietGepland ASC, {psSortOrder} ASC When I move the line: LEFT OUTER JOIN FileFlock ON TblEdkInleg.CodeFlockCD = FileFlock.CodeFlockCD one line up, I get the warning on CodeFlockCD of TblEdkInleg.CodeFlockCD in the joins. It looks like it has something to do with the number of joins. What am I missing?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-solved-61048/read.awp30 May 2017 13:10:00 ZHi Jonathan, I've found what the problem was. All joins where without commas which means that they where seemingly joined wit…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-solved-61048/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-solved-61048/read.awp[WD22] Warning in queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61047/read.awp30 May 2017 12:46:00 ZHi Jonathan, FROM TblEdkKoppel LEFT OUTER JOIN TblHok ON TblHok.tblHokID = TblEdkKoppel.tblHokID LEFT OUTER JOIN TblRas ON Tb…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61047/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61047/read.awp[WD22] Warning in queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61046/read.awp30 May 2017 11:31:00 ZYou have to JOIN first the FileFlock before use it! LEFT OUTER JOIN TblRelatie AS TblRelatieVoerlev ON TblRelatieVoerlev.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61046/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60988-wd22-warning-query-61046/read.awp[WD22] Warning in query