mysql_query("select kehu,kehuyingfu,fujiafei,qitafei,guohkfei,yunfeizong,shou_zhifujin,kehuyingfu+fujiafei-shou_zhifujin as weifu from (select kehu,sum(kehuyingfu) as kehuyingfu,sum(fujiafei) as fujiafei,sum(qitafei) as qitafei,sum(guohkfei) as guohkfei,sum(yunfeizong) as yunfeizong from `$biao` where 1 $xuannianyue group by kehu)a left join (select shou_kehu,sum(shou_zhifujin) as shou_zhifujin from `$biao_yingshou` where shou_date='$like_date' group by shou_kehu)b on (a.kehu=b.shou_kehu)")紅色的部份如果shou_zhifujin沒有值,那麼weifu都沒有值出來
应写作
IFNULL(kehuyingfu,0)+IFNULL(fujiafei,0)-IFNULL(shou_zhifujin,0)