[RndTbl] SQL problem

Adam Thompson athompso at athompso.net
Thu Mar 24 09:21:40 CDT 2016


If they don't work, upgrade to a newer version of MariaDB.  (If this is the customer I assume it is, use RackSpace's IUS repo to upgrade).

Alternately, create two VIEWs, one for each aggregate count, and OUTER JOIN them.

On March 24, 2016 9:16:31 AM CDT, Trevor Cordes <trevor at tecnopolis.ca> wrote:
>Can anyone help me figure out how to do this in SQL (MySQL)?
>(pseudo-code giving you the gist):
>SELECT custid, (count orders where ttl=X), (count orders where ttl=Y)
>FROM ordertable
>GROUP BY custid;
>I basically want to count two different things based on two different 
>wheres.  If I put in a where clause then I select either the X or the Y
>but I can't seem to get both in such a way I can count the X's and Y's.
> I 
>tried thinking about unions but couldn't make it work.  I want to do
>all in 1 query as I want the sorted union of all custid's (X and Y).
>P.S. ordertable has/can have multiple entries for each custid.
>Ideas are appreciated!
>Roundtable mailing list
>Roundtable at muug.mb.ca

Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.muug.mb.ca/pipermail/roundtable/attachments/20160324/0c647aef/attachment.html>

More information about the Roundtable mailing list