select sum(t1. 总价) as T1总和,sum(t2. 总价) as T2总和,sum(t3. 总价) as T3总和,sum(t4. 总价) as T4总和 ,sum(t1. 总价) +(t2. 总价) +sum(t3. 总价) -sum(t4. 总价) as 54总和
from t1,t2,t3,t4,t4
where t1.名称=t2.名称 and t1.名称=t3.名称 and t1.名称=t4.名称
from t1,t2,t3,t4,t4
where t1.名称=t2.名称 and t1.名称=t3.名称 and t1.名称=t4.名称
select sum(t1. 总价) as T1总和,sum(t2. 总价) as T2总和,sum(t3. 总价) as T3总和,sum(t4. 总价) as T4总和 ,sum(t1. 总价) +(t2. 总价) +sum(t3. 总价) -sum(t4. 总价) as 54总和
from t1,t2,t3,t4,t4
where t1.名称=t2.名称 and t1.名称=t3.名称 and t1.名称=t4.名称
where t1.名称=t2.名称 and t1.名称=t3.名称 and t1.名称=t4.名称
但。。出现了问题!!
上面语句基本思路是正确的~~
但。。得出来的结果不正确~~~
SUM(总和)这些命令求出的总和不正确~~~
说明。。我总和的字段属性是decimal,并且小数设置成2位
每一个总和。。处第一个总和吻合外~~其他的都多了很多~~~有的甚至数字大的离谱~~~
比如我T2中有3条记录~~实际总和应该是890,这条语句算出来后就变成了1000多!!!这是怎么回事??大家能帮帮我么??谢谢!!