🚀 go-pugleaf

If you have only one DATE2 for each CLIENTID than you should use aggregate
on DATE2 as well:

select CLEINTID, min(DATE1), min(DATE2)
from yourtable
group by CLEINTID

By the way, it means your database is not normalized enough in this case.

If there are different DATE2 values for each CLIENTID than you can do
something like this

select CLIENTID, DATE2,
  (select min(yt2.DATE1) from yourtable yt2 where yt2.CLIENTID -
yt1.CLIENTID)
from yourtable yt1

Maxim.

"aleplgr" <aleplgr@yahoo.es> �������/�������� � �������� ���������:
news:4625f0e8@newsgroups.borland.com...
>
> 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 table, 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..
>