RE: Order by another query

2008-06-02 Thread William
It looks like it should return a result for you. I would suggest adding the 'posted desc' to the order by of the query in a query line, in case your messages are not sorting correctly. william William Seiter (mobile) Have you ever read a book that changed your life? go to:

Re: Order by another query

2008-06-02 Thread Phillip Vector
It only returned 1 record because (I would assume) that ThreadID would be the last record once it reached there. I worked around it though. When someone posts a message, I update the first thread with the last posted date and sort on that. :) Feels a little like a kludge, but it's clean enough