> > If this is the case, is there a crude workaround method of > attempting to > perform the following until such a time as it is? > > SELECT COUNT(*) FROM messages WHERE forum_id IN (SELECT forum_id FROM > forums WHERE team_no = 400)
select count(message_id) -- assuming you have a non-null id column from messages m inner join forums f on m.forum_id=f.forun_id where team_id=400 This will give the wrong result if a message can appear in more than one forum. In that case use count distinct(message_id) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]