Re: UNION ALL and GROUP BY

Chris <[EMAIL PROTECTED]> wrote on 04/02/2005 12:35:57 AM: > Tom Crimmins wrote: > > >On Friday, April 01, 2005 19:27, Chris wrote: > > > > > > > >>Hi all, > >> > >>I've got 3 or 4 queries UNIONed together in a single query. I want to > >>GROUP the UNIONed result, by one field, and SUM() another

Re: UNION ALL and GROUP BY

Tom Crimmins wrote: On Friday, April 01, 2005 19:27, Chris wrote: Hi all, I've got 3 or 4 queries UNIONed together in a single query. I want to GROUP the UNIONed result, by one field, and SUM() another field. Is that possible in one query, or will I need to use temporary table and group it from

RE: UNION ALL and GROUP BY

On Friday, April 01, 2005 19:27, Chris wrote: > Hi all, > > I've got 3 or 4 queries UNIONed together in a single query. I want to > GROUP the UNIONed result, by one field, and SUM() another field. > > Is that possible in one query, or will I need to use temporary table > and group it from that?

UNION ALL and GROUP BY

Hi all, I've got 3 or 4 queries UNIONed together in a single query. I want to GROUP the UNIONed result, by one field, and SUM() another field. Is that possible in one query, or will I need to use temporary table and group it from that? Thanks, Chris -- MySQL General Mailing List For list archiv