> > select * > > from ( select * from msgs order by msgs.created desc ) t > > where sender = 1 or recipient = 1 > > group by sender, recipient > > not quite right. first comes all of MY newest messages, then comes all > of THEIR newest messages. for example: > > S R > 1 2 > 1 3 > 1 5 > 1 7 > 2 1 > 5 1 > > the final result should include EITHER "1 2" OR "2 1", depending on > which of the two is newest. same for "1 5" and "5 1".
So, a newest message from "me to A" would exclude the newest message from "A to me" (depending, of course, on the creation date)? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
