kamkam
02-02-2008, 07:55 AM
Hi;
i'd like to ask you how to write a query to get the final result same as table3 from table 1, please click the Link (http:/ffff.org/AskQuestion2.php).
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.
and also if the threadId not equal each other, then the row with biggest value of the Postime, should be selected first
i'd like to ask you how to write a query to get the final result same as table3 from table 1, please click the Link (http:/ffff.org/AskQuestion2.php).
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.
and also if the threadId not equal each other, then the row with biggest value of the Postime, should be selected first