Re: [SQL] Having the sum of two queries

[Roberto Spier]

Dani Castaños escreveu:

...

And have the result of both added.

I've tried something like

SELECT tot.status, COUNT(total)

Should be

SELECT tot.status, SUM(total)

FROM( QUERY A UNION QUERY B ) AS tot
GROUP BY tot.status

But it doesn't works. It doesn't add the total columns with the same status...

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings