This query should work SELECT * FROM t1 ; WHERE STR(EmpId) + Dtos(EffectiveDate) IN ( ; Select Str(EmpID) + Dtos(max(EffectiveDate)) ; from t1 ; where EffectiveDate <= ?dParam ; group by EmpID )...but it gives the following result...
EmpID EffectiveDate Value 1 {3/4/2} 18...instead of th wished result:
EmpID EffectiveDate Value 1 {3/4/2} 18 2 {4/5/2} 18 3 {1/1/1} 7What I'm missing?