Sorting INNER JOIN
Posted on 2004-09-04
My problem lies here:
I have a message board running on MS-SQL. I want to sort the topics in order of last reply. I have a TOPICS table, USERNAMES table and a POSTS table. To display an asp page, I need to get the thread title, thread id, username of last person to reply and order these results by time of last reply. Ideally, this should be one sql statement but I can't get it to work.
I'm assuming this is going to take a subquery to get the latest post where POSTS.thread_id is the same as the thread id.
Can anyone help?