Subject Re: [firebird-support] Min and Max from detail table
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil