Dear Sir:
The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5.
I have a problem with below SQL Statement
"Select Sum(Cost) as TotalCost from Item"
All the entries for Cost Field has the Value Null. The result of this Query
is TotalCost = 0.
But is not it suppose to be Null instead of 0.
Because when i try
"Select Avg(Cost) as TotalCost from Item"
OR
"Select Max(Cost) as TotalCost from Item"
The result of this Average Query is TotalCost = Null.
Regards
Jack Chan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
