--- In firebird-support@yahoogroups.com, David C <dac2002lion@y...>
wrote:

> Hi
>
> I wonder if firebird support on his language SQL ,
> Group by statement on Union statement
>
> like this:
>
> Selec t1.field1, t1.field2, t1.field3
> from table1 t1
> union
> Selec t2.field1, t2.field2, t2.field3
> from table2 t2
> group by 1,2 --> this is possible over all Union
> statement
>

Sure,
make the union query a storedprocedure
and
select field1, field2, field3 from storedprocedure group by field1,
field2, field3

> Thanks for your help

HTH

>
>
> David Contreras
> Developer

CUIN Kaczy

>
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com