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

Thanks for your help


David Contreras
Developer




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