How do I do a UNION?

[shyce]

I'm trying to do something like is described in this article...

http://codeidol.com/sql/sql-hack/Number-Crunching/Get-Values-and-Subtotals-in-One-Shot/


However, I don't know how to perform a UNION with my dbForge Query Builder for MySQL.

[shyce]

Nevermind, GROUP BY WITH ROLLUP was the solution to this.

[.jp]

Unfortunately a UNION clause is not supported by dbForge tools so far.