Thanks very much to all collaborators.

This evening I try all your's solutions, and I reply the best Query.

Thanks again!
Bey
Alberto Pesce

>
> Hi
>
> > Hi all,
> >
> > why this union don't work:
> >
> > SELECT SUM(A), B, C, D
> > FROM X,T,Z
> > WHERE set_condition_1
> > GROUP BY B, C, D, A
> > ORDER BY B
> >
> > UNION ALL
> >
> > SELECT SUM(A), B, C, D
> > FROM X,T,Z
> > WHERE set_condition_2
> > GROUP BY B, C, D, A
> > ORDER BY B
> >
> > The queries above (separated) work fine but if I use the
> > statemant union I obtain a SQL error.
>
> What about:
>
> SELECT SUM(A), B, C, D
> FROM X,T,Z
> WHERE set_condition_1 OR set_condition_2
> GROUP BY B, C, D, A
> ORDER BY B
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

____________________________________________________________
Navighi a 2 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it