On 24 Dec 2009, at 11:18, Randy Moller wrote: > You could use a group by based on the event location to get the > count by group.
That's closer, but the subquery now returns multiple rows. I still need a way to only select the rows (for the count) from the many-to- many table for events users are registered for that match the row currently being selected from the main query I need a meev.meev_even_id=even.even_id somewhere. _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
