Rommel : >> How about: SELECT DISTINCT ClientID,MAX(DateTimeOrder) FROM Orders GROUP BY ClientID <<
Very good idea ... I builded a view that contains the more recent row for each link status+titre. This allow to proceed only thoses rows : CREATE TEMPORARY VIEW vt_session + (status, titre, date_env) + AS SELECT + status, + titre, + MAX(date_env) + FROM t_session WHERE status = 'E' GROUPED BY status, titre Thanks for your help, J.M. GRATIAS, Logimatique ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
