Ed Dressel wrote:

> I need a min and max value from a detail table. Something like:
>
> select T1.Client_ID, Min(T2.Value1), Max(T2.Value2)
> from Table1 T1 left outer join T2 on T1.Client_ID = T2.Client_ID
> where...
> group by 1
>
> can this be done without a stored proc?
>
> Thanks in advance,
>
> Ed Dressel
>

Yes, just like you did :-)

What the problems do you have ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br