quote:

---

Originally posted by trsisko

I have the following query. I have a problem with this and need help. I am trying to ensure that only the entries with max effdate is shown from the membercontributionrates table. Problem is it doesnt appear to work. Please help


select *
from person m
join employee a on a.personuid = m.personuid
join schememember b on a.employeeuid = b.employeeuid
join memberbenefit c on b.memberuid = c.memberuid
join benefit d on c.benefituid = d.benefituid
join membercontributionrates e on a.employeeuid = e.parentuid
inner join (
select parentuid, max(Effdate) Effdate
from membercontributionrates
group by parentuid) addstripped
on e.parentuid = addstripped.parentuid
and e.Effdate = addstripped.Effdate
where m.nationalIDnumber = ''
and e.rate <> .00

---