I'm converting from LassoMySQL (MySQL 3.23.54) to the current version of MySQL, and I'm running into a query problem.
(sum(Rush)+sum(Rec)+sum(KO)+sum(Punt)+sum(Inter)+sum(Fum)+sum(BP)) as TDs Previously, this would produce a valid number. But now, I'm getting "NULL". This is a sports database for a newspaper, and we calculate individual player stats via MySQL. All of these fields are the different methods a player can score; rushing, receiving, kick off, punt, etc. So obviously, some fields will have null values. It appears that this query in MySQL 4.0.21 doesn't work because there are null values in some of the fields. How can I get around this? Thanks Keith Warren Systems Editor The Clarion-Ledger 601-961-7058 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
