Hello, What would be the proper way of generating a query like the following;
SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id; Assuming the table looks like this; Sales: Id| totalsales| monthyear 1 | 100 | 2003-09 1 | 10000 | 2003-08 1 | 2000 | 2003-07 2 | 30000 | 2003-05 3 | 10000 | 2003-06 3 | 10000 | 2003-05 I want the query to return id 1 and 2 as the sum of their totalsales is smaller then 20000. Thanks for your help, Best, Yoed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]