My query:
Basically, I want to count the number of postids and threadids that result in the 'p.boardid = b.boardid' and 't.boardid = b.boardid' and grab two columns from the main table (board).SELECT COUNT(p.postid), COUNT(t.threadid), b.boardid, b.display FROM `bmb_boards` b, `bmb_posts` p, `bmb_threads` t WHERE p.boardid = b.boardid AND t.boardid = b.boardid ORDER BY b.boardid ASC
MySQL Error: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
