query

[xbl01234]

Hi;
i'd like to ask you how to write a query to get the final result same as table3 from Link [writeanything.org].

But please write in mysql

my question:
i got a table which is SubThread. i want to get everything relative to userName of kam.
But if the threadId equal each other, i just want to select the row which is the biggest value of the postTime.

[xbl01234]

Thanks to come here, i have found out the solution already