> -----Ursprüngliche Nachricht----- > Von: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 18. September 2006 23:28 > An: mysql@lists.mysql.com > Betreff: SUM in WHERE > [...] > > I want to run SQL query that will return to me the first > records that the > SUM of Total field = 100 > > for example > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID > > I know my SQL statment above will not work, could someone help me ?
So what result do you expect from your query? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]