> i have a message table like this:
> created datetime
> sender int
> recipient int
> message text
> to get all my messages i would do:
> select * from message where sender = $MYID or recipient = $MYID
> but how do i make a query that returns the rows of only the NEWEST
> messages between myself and my contacts (regardless of who sent the
> newest message)?
> i tried using "group-wise maximum" mentioned in the mysql manual, but
> can't figure it out. hope someone can help. thanks!
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!