UNION ALL gave the correct result

Salim

--- In firebird-support@yahoogroups.com, Nick Upson <nick@u...> wrote:
> Does "UNION ALL" instead of UNION give the result you expect
>
> In article <000001c4681b$75bef0f0$0b00a8c0@t2450>, Salim Naufal
wrote:
> > SELECT SUM(AMOUNT)
> > FROM TBL
> > WHERE TYPE_OF_ROW = 0
> > GROUP BY TYPE_OF_ROW
> > UNION
> > SELECT AMOUNT
> > FROM TBL
> > WHERE TYPE_OF_ROW <> 0
> >
>
> --
> Nick