brianlange Posted January 16, 2010 Share Posted January 16, 2010 I have an online forum and have an issue where replies have a earlier `created` date than the first post in the thread. I need to query for all thread posts that have a reply with an earlier `created` date. I want to write a query like this "SELECT id, thread_id, created from posts where thread_id in (Sub query for replies order by created desc limit one and created is greater than the created value in the first post) Am I making sense? I know I could loop through all the records with php and check for this type of thing, but I was hoping to do it with a single query. Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 16, 2010 Share Posted January 16, 2010 Try thinking about this from the inside-out, then piece the query back together. 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.