2011/10/24 16:31 -0700, Daevid Vincent
WHERE cs.customer_id = 7
GROUP BY customer_id
Well, the latter line is now redundant.
How will you make the '7' into a parameter?
--
MySQL General Mailing List
For list archives:
A kind (and shy) soul replied to me off list and suggested this solution,
however,
this takes 28 seconds (that's for a single customer_id, so this is not going
to scale).
Got any other suggestions? :-)
SELECT
c.customer_id,
c.email,
c.name,
c.username,
To: mysql@lists.mysql.com
Subject: RE: Within-group aggregate query help please - customers and
latest
subscription row
A kind (and shy) soul replied to me off list and suggested this solution,
however,
this takes 28 seconds (that's for a single customer_id, so this is not
going
to scale).
Got