Exactly. 2008/4/28, Martijn Tonies <[EMAIL PROTECTED]>: > > > > 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]