Re: Max

>>>>> "Alain" == Alain <Alain_at_o.fr> writes:

 Alain> Thanks, but it doesn't work... because it's my fault : I  Alain> haven't given all information : In fact, I have :

 Alain> ID TX Date
 Alain> -- -- -----
 Alain> 1 3 2002-01-01 1 4 2002-05-01 1 5 2002-03-01 2 7 2002-01-01 3
 Alain> 1 2002-02-01 3 8 2003-02-01

 Alain> And I would want the TX for the max(Date) only for eg ID=1...

 Alain> Thanks again.

 Alain> -- Ce message a ete poste via la plateforme Web
 Alain> club-Internet.fr This message has been posted by the Web
 Alain> platform club-Internet.fr

 Alain> http://forums.club-internet.fr/

Use a GROUP BY on your id field. This will give you the max date for each ID.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!