It sounds more like he wants to query for the latest topics and bring back the latest reply to each of those topics in a joined result as opposed to querying for the latest reply and joining the topic -- a subtle but important difference.

I'm not entirely sure that what is being asked for can be done with a single query (prove me wrong ).