Since your on 4.1, give this a try...
select *
from tbl as a
where a.recdate=(select max(b.recdate)
from tbl as b
where b.id=a.id and b.mount=a.mount)
Ed
-Original Message-
From: Duncan Hill [mailto:[EMAIL PROTECTED]
Subject: Re: Query help with
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 |
> >
> > ++-+-
Egor Egorov <[EMAIL PROTECTED]> wrote:
> Duncan Hill <[EMAIL PROTECTED]> wrote:
>> I have a table that has data that looks like:
>> ++-+---+-+
>> | id | recdate | mount | perused |
>> ++-+---+-+
>> | 1 | 2004-05-20
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
