Hi again ;) > SELECT COUNT(*) > FROM test > WHERE (kid=1) OR (kid=2) OR (kid=4) > GROUP BY cid,aid; This query returns: +----------+ | COUNT(*) | +----------+ | 1 | | 1 | | 2 | | 1 | | 1 | | 1 | +----------+ 6 rows in set (0.03 sec)
Inest of this I want to get back '6' << so numbers of rows in resulting query; The same query WITHOUT 'GROUP BY' returns: mysql> SELECT COUNT(*) FROM test WHERE (kid=1) OR (kid=2) OR (kid=4); +----------+ | COUNT(*) | +----------+ | 7 | +----------+ 1 row in set (0.00 sec) So two rows are grouped because of same cid,did Any sugestion? Regards, Dezo --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php