selecting the last row of the GROUP BY
Posted: Sat Mar 05, 2011 10:59 am
How would i go about selecting the last row of the GROUP BY ?
Thanks in Advance
Code: Select all
SELECT * FROM messaging INNER JOIN messaging_subject ON messaging.subject_id = messaging_subject.subjectID WHERE messaging.user_id = '$userID' GROUP BY messaging.conversation_id ORDER BY messaging.date_sent DESC