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.

Michel, when you say "most recent", do you mean ordered by a specific date?

If you can post your DDL for the tables, that might help...