>I have a master table which contains some clients. For each clients, I need to locate the most recent records in the child table. I have done that a few times but cannot remember to cleanest way to do it.
This should get you started
SELECT * FROM ChildTable ct WHERE NOT EXISTS (SELECT 1 FROM ChildTable WHERE pk = ct.pk and SomeDate > ct.SomeDate)
--sb--