Subquery returns more than one row.

[1andyw]

I need to count the number of unique visitors attending during any period, with a sum of each status. This query returns the error "Subquery returns more than one row." How can I work around this?

CREATE TABLE `memlog` (
	`log_id` INT(10) NOT NULL AUTO_INCREMENT,
	`m_id` INT(10) NOT NULL,
	`name` VARCHAR(60) NOT NULL DEFAULT '\'\'',
	`date` DATE NOT NULL DEFAULT '0000-00-00',
	`status` VARCHAR(10) NOT NULL DEFAULT 'Verified',
	PRIMARY KEY (`log_id`)
)

query:

SELECT  COUNT(`status`),`status` FROM memlog 
WHERE (`date` BETWEEN '2011-01-01' AND '2011-03-01')
AND (SELECT DISTINCT m_id FROM memlog)
GROUP BY `status`

Thanks,

Andy

[guido2004]

SELECT 
    `status`
  , COUNT(DISTINCT m_id) AS total
FROM memlog
WHERE `date` BETWEEN '2011-01-01' AND '2011-03-01'
GROUP BY `status`

[1andyw]

Super! Thanks, Guido.