Posted by Sean on 11/29/05 20:09

Follow this up in the sql forums, but you want something like this:

SELECT b.BREWERY_CODE, b.BREWERY, COUNT(c.id) as num_coaster
FROM breweries b LEFT JOIN coasters c ON b.BREWERY_CODE =
c.BREWERY_CODE
Group by b.BREWERY_CODE
order by COUNT(c.id) DESC

UNTESTED!

This will get you what you want in one pass. (i think)

• Next in forum: Re: setting up a A/B split test with PHP
• Prev in forum: Re: confused: casting a variable to integer
• Thread view: Re: Sort array from a Query

[Reply to this message]