Re: select count(). Help-a-newb

[contiw <walter@xxxxxxxxxx>]

Thank You Richard! Merci beaucoup.
wConti


Richard-175 wrote:
> 
> Hi I think you would do this :
> 
> SELECT
> sf_conferences.id,
> sf_conferences.name,
> count(*) AS `count`
> FROM
> ((
> LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
> LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
> LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
> GROUP BY
> sf_conferences.id,
> sf_conferences.name;
> 
> I hope this is what you want :)
> 
> contiw a écrit :
>> Is it possible to get the count() for "forums, "threads" and "messages"
>> extrapolating from the following query? Thanx for helping a newb. 
>> 
>> select 
>> sf_conferences.id, 
>> sf_conferences.name 
>> from 
>> ((#variables.tableprefix#conferences 
>> left JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk) 
>> left JOIN sf_threads ON sf_forums.id = sf_threads.forumidfk) 
>> left JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk 
>> GROUP BY 
>> sf_conferences.id, 
>> sf_conferences.name
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@xxxxxxxxxx
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/select-count%28%29.-Help-a-newb-tp16582786p16590541.html
Sent from the MySQL - General mailing list archive at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx