query bug

[ashish4172]

hi

I have a problem in query.I'm implementing the last posted reply
of threads.How can i get the recent replier of thread without using subquery
as i have mysql4 which doesn't support subquery...
please help..


table:thread_reply
fields: thread_id,thread_reply_date,thread_replier

i have tried

select thread_replier,max(thread_reply_date) from thread_reply group by thread_id;

datetime is stored in date field...

Pl help

Ashish Sharma