select count(). Help-a-newb
- Date: Wed, 9 Apr 2008 02:12:56 -0700 (PDT)
- From: contiw <walter@xxxxxxxxxx>
- Subject: select count(). Help-a-newb
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
--
View this message in context: http://www.nabble.com/select-count%28%29.-Help-a-newb-tp16582786p16582786.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