order by subselect

Her er SQL'en:

SELECT threads.id, threads.name, threads.headline, threads.datetime,
(SELECT COUNT(*) FROM messages WHERE messages.threadid=threads.id) AS replies,
(SELECT TOP 1 [datetime] FROM messages WHERE messages.threadid=threads.id ORDER BY messages.id desc) AS lastreplywhen,
(SELECT top 1 name FROM messages WHERE messages.threadid=threads.id ORDER BY messages.id desc) AS lastreplyby
FROM threads ORDER BY threads.datetime DESC;

Try making the sub select in a query and then add this query to the query as though it were a table.

and how would I do that??

juggalo>If you send me your dB I will take a look. eksperten@santhell.dk

do you still need help here?

I sure do - but my database is of no importance - this is a pure SQL question...

prøv at sorterel med: ... order by 1 desc

But I can NOT see your table or data and it makes thing MUCH easier, but then what the heck, it isnt me who needs help :o)

Lukker