>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} 7 >>What I'm missing?