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...