How do you structure a sql statement such as SELECT a, COUNT(a) AS b FROM tbl WHERE b > 1 GROUP BY a I am looking for only the records which report a count greater than one. MySQL complains that column 'b' does not exist. -Mike