Page 1 of 1

How do I do a UNION?

Posted: Mon 30 Apr 2012 15:32
by 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.

Re: How do I do a UNION?

Posted: Mon 30 Apr 2012 16:20
by shyce
Nevermind, GROUP BY WITH ROLLUP was the solution to this.

Re: How do I do a UNION?

Posted: Thu 03 May 2012 07:28
by .jp
Unfortunately a UNION clause is not supported by dbForge tools so far.