ashish4172 Posted March 8, 2006 Share Posted March 8, 2006 hiI have a problem in query.I'm implementing the last posted replyof threads.How can i get the recent replier of thread without using subqueryas i have mysql4 which doesn't support subquery...please help..table:thread_replyfields: thread_id,thread_reply_date,thread_replieri have triedselect thread_replier,max(thread_reply_date) from thread_reply group by thread_id;datetime is stored in date field...Pl helpAshish Sharma Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.