仅有的10分，请高手看看小弟的SQL语句有什么问题？关注……

[StarCraftPJF]

请看我的SQL语句：
1、SELECT TruckCostSumView.TheMonth, Max(TruckCostSumView.TheAllFee) AS TheCostFee, (SUM(CASE WHEN TransFeeView.[InComeOrOut] =

'应收' THEN CONVERT(float, TransFeeView.AllFee) ELSE - CONVERT(float, TransFeeView.AllFee) END)) AS 'OtherTruckFee'

from TruckCostSumView

LEFT JOin TransFeeView ON (RIGHT(TruckCostSumView.[TheMonth], 2) = substring(TransFeeView.[BeginDate], 6, 2) AND LEFT

(TruckCostSumView.[TheMonth], 4) = LEFT(TransFeeView.[BeginDate], 4))

GROUP BY TruckCostSumView.[TheMonth]

[baggio328]

第一个程序是两个表外联
第二个是三个表外联吧
我觉得区别可能是这样
看了看 as OtherTruckFee
似乎没什么不同

[StarCraftPJF]

2、SELECT TruckCostSumView.TheMonth, Max(TruckCostSumView.TheAllFee) AS TheCostFee, Sum(CASE WHEN TruckFee.MyTruck = '1' THEN

ConVert(float, TruckFee.AllFee) ELSE 0 END) AS 'MyTruckFee', (SUM(CASE WHEN TransFeeView.[InComeOrOut] = '应收' THEN

CONVERT(float, TransFeeView.AllFee) ELSE - CONVERT(float, TransFeeView.AllFee) END)) AS 'OtherTruckFee'

from TruckCostSumView
LEFT JOin TruckFee ON (RIGHT(TruckCostSumView.[TheMonth], 2) = substring(TruckFee.[BillDate], 6, 2) AND LEFT

(TruckCostSumView.[TheMonth], 4) = LEFT(TruckFee.[BillDate], 4))

LEFT JOin TransFeeView ON (RIGHT(TruckCostSumView.[TheMonth], 2) = substring(TransFeeView.[BeginDate], 6, 2) AND LEFT

(TruckCostSumView.[TheMonth], 4) = LEFT(TransFeeView.[BeginDate], 4))

GROUP BY TruckCostSumView.[TheMonth]

[StarCraftPJF]

这两个SQL语句中得到的“OtherTruckFee”竟然是不一样的！！

小弟想了很久也没有找到问题所在，请高手指点一下！！！

如果我想要在第二个SQL中得到的“OtherTruckFee”值和第一个SQL中的相同，第二个SQL语句要怎么修改？？

学习，关注……

[StarCraftPJF]

自己先顶一下吧………………