[RndTbl] SQL problem

[Adam Thompson]

Subqueries:
SELECT (SELECT ...), (SELECT ...) FROM ...

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.
-Adam


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
>this 
>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
>http://www.muug.mb.ca/mailman/listinfo/roundtable

-- 
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>