Not sure if this what you mean. In my project I had to list the latest record with data from linked tables. My query was (with names changed), you can add other columns you need:
string query = "select StartTimestamp from Table1, Table2 ";
query += "where Table1.ID=Table2.ID ";
query += "and StartTimestamp in (select MAX(StartTimestamp) from Table1)";
You could also use SELECT TOP command after sorting.