From: Martijn Tonies
Date: April 28 2008 3:58pm
Subject: Re: get all my newest messages
List-Archive: http://lists.mysql.com/mysql/212564
Message-Id: <020601c8a948$b2bb06c0$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> >  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