ok thanks ... I understand... sorry

Alan McDonald <alan@...> escribió: > Hi! I have a 3 columns table: CLIENTID DATE1 DATE2

> for each CLIENTID can be more than one DATE1 so I have to select
> the MIN. Just doing this works fine:
> SELECT MIN (DATE1)
> from mytable
> group by CLIENTID
> Now I need also to show DATE2 in the result, if I include it in
> the SELECT I need to include it in the GROUP BY but if I do that
> I don't get the MIN(DATE1)for each CLIENTID: it returns all of them..
>

if you want an aggregate/sum of date2 then
SELECT CLIENTID, MIN(DATE1), MIN(DATE2) FROM MYTABLE
GROUP BY CLIENTID
will do - if you don't want an aggregate/min/sum of a filed then your logic
is faulty.
Which, exactly, DATE2 value would you want adjacent to the clientid when
MIN(DATE1) is returned?

Alan






---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]