[snip] SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id; [/snip]
SELECT id, SUM(totalsales) AS TotalSales FROM sales GROUP BY id HAVING TotalSales <= '20000' HTH! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]