Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null?
Phrased another way, is there a way to make mySQL treat "NULL" as "0" when dealing with mathematical functions? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/
smime.p7s
Description: S/MIME cryptographic signature
