CodingForums.com - View Single Post

Old Pedant · 12-08-2012, 12:26 AM

Oh, sure...

Just add that as WHERE.

Code:

SELECT M1.id, M1.to_id, M1.from_id, M1.message, M1.`date` AS originalMessageDate,
       MAX( IFNULL(M2.`date`,M1.`date`) )AS lastReplyDate
FROM messages AS M1 LEFT JOIN messages AS M2
ON M1.id = M2.original_messsage_id
WHERE M1.original_message_id = 0
GROUP BY M1.id, M1.to_id, M1.from_id, M1.message, M1.`date1
ORDER BY lastReplyDate DESC

12-08-2012, 12:26 AM	PM User \| #4
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,993 Times in 3,962 Posts	Oh, sure... Just add that as WHERE. Code: SELECT M1.id, M1.to_id, M1.from_id, M1.message, M1.`date` AS originalMessageDate, MAX( IFNULL(M2.`date`,M1.`date`) )AS lastReplyDate FROM messages AS M1 LEFT JOIN messages AS M2 ON M1.id = M2.original_messsage_id WHERE M1.original_message_id = 0 GROUP BY M1.id, M1.to_id, M1.from_id, M1.message, M1.`date1 ORDER BY lastReplyDate DESC __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.