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