On Thursday 20 May 2004 12:49, Egor Egorov might have typed: > Duncan Hill <[EMAIL PROTECTED]> wrote: > > I have a table that has data that looks like: > > +----+---------------------+-------+---------+ > > > > | id | recdate | mount | perused | > > > > +----+---------------------+-------+---------+ > > > > | 1 | 2004-05-20 10:46:12 | QUAR | 80 | > > | 2 | 2004-05-20 11:05:11 | QUAR | 99 | > > | 2 | 2004-05-20 11:33:27 | ROOT | 99 | > > | 2 | 2004-05-20 11:33:34 | QUAR | 88 | > >
> From version 4.1 subquery helps you to get result using one query. Thanks Egor, I'll start poking at it using subqueries, as I'm running 4.1.1. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]