pcsoft.us.windevCopyright 2026, PC SOFT4 Dec 2015 13:39:00 Z4 Dec 2015 11:35:00 ZHi, I have a SQL-coding problem and would like to ask for tips. I have 2 files TblBox and TblBoxMutatie like in the picture, with a 1:n relation, so one TblBox can have several TblBoxMutatie records: I would like to create a list of unique TblBox-records with items TblBoxID, Boxnummer, TblKaastypeID and the items TblBoxMutatieID, TblLocatieID, Mutatietijd from file TblBoxMutatie, but for each TblBox-record only using 1 TblBoxMutatie-record. Depending on a parameter pardtDateTime (containing a datetime value) I want the TblBoxMutatie-record with the highest Mutatietijd value before this parameter value. I've tried already. I can get the highest TblBoxMutatie.Mutatietijd value per TblBox, but I cannot get more items from that same TblBoxMutatie record. Someone can help me with the best way to get this via SQL, if possible ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55308/read.awp4 Dec 2015 13:39:00 ZHi Paulo, this works indeed. Thank you for your effort.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55308/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55308/read.awp[OT] SQL questionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55307/read.awp4 Dec 2015 12:41:00 Ztry with something like this (not tested): Select TblBoxID, Boxnummer, TblKaastypeID,TblLocatieID, Mutatietijd from TblBox …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55307/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55303-sql-question-55307/read.awp[OT] SQL question