Then tack on the id=1 in the outer sql statement. Look at Guido's statement
again.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Alain" <Alain_at_o.fr> wrote in message
news:2003131-155236-279747_at_foorum.com...
>
> Thanks, but it doesn't work... because it's my fault : I haven't given all
> information :
> In fact, I have :
>
> ID TX Date
> -- -- -----
> 1 3 2002-01-01
> 1 4 2002-05-01
> 1 5 2002-03-01
> 2 7 2002-01-01
> 3 1 2002-02-01
> 3 8 2003-02-01
>
> And I would want the TX for the max(Date) only for eg ID=1...
>
> Thanks again.
>
> --
> Ce message a ete poste via la plateforme Web club-Internet.fr
> This message has been posted by the Web platform club-Internet.fr
>
> http://forums.club-internet.fr/
Received on Fri Jan 31 2003 - 10:57:45 CST
