再来问个简单的问题哈 在线等！！！！！！

Question

怎么样才能把这个2个表合成一张表
select  OrderDetailName,CostPrice,SalePrice,Number ,SupplierName,sum(SalePrice*Number) as yingshou,sum(CostPrice*Number) as yingfu  from SupplierInfo,OrderDetail where OrderDetail.SupplierId=SupplierInfo.SupplierId group by OrderDetailName,CostPrice,SalePrice,Number,SupplierNameselect sum(CostPrice*Number) as 成本总价,sum(SalePrice*Number) as 销售总价 from OrderDetail 
where SupplierId=7我现在是这样写 不知道怎么合了 请教大家一下

Answer 1

 说错了 开了空调了 这么冷 我看了下我的cpu53度...

Answer 2

select OrderDetailName,CostPrice,SalePrice,Number ,SupplierName,sum(SalePrice*Number) as yingshou,sum(CostPrice*Number) as yingfu from SupplierInfo,OrderDetail where OrderDetail.SupplierId=SupplierInfo.SupplierId group by OrderDetailName,CostPrice,SalePrice,Number,SupplierName
union all
select '总价',sum(CostPrice*Number),sum(SalePrice*Number),null,'',null,null from OrderDetail  
where SupplierId=7

Answer 3

我想 yingshou yingfu 成本总价 销售总价 
  就是这样合的这是2张表
 

Answer 4

呃,貌似应该放在最后面:
select OrderDetailName,CostPrice,SalePrice,Number ,SupplierName,sum(SalePrice*Number) as yingshou,sum(CostPrice*Number) as yingfu from SupplierInfo,OrderDetail where OrderDetail.SupplierId=SupplierInfo.SupplierId group by OrderDetailName,CostPrice,SalePrice,Number,SupplierName
union all
select '总价',null,null,null,'',sum(CostPrice*Number),sum(SalePrice*Number) from OrderDetail  
where SupplierId=7

Answer 5

不知道你第一张表的数据是不是也是SupplierId=7的，如果不是，你这样加一行合计也不对。

Answer 6

SupplierId=7 这个其实 是我随便查起玩的  可以不用加 我是想加最后的总数

Answer 7

是这样的 
 但是 我想总价 在yingshou  yinggu 后面显示

Answer 8

那你union一行，sum(字段)，不需要sum的用null 就可以了。

Answer 9

select OrderDetailName,CostPrice,SalePrice,Number ,SupplierName,
sum(SalePrice*Number) as yingshou,sum(CostPrice*Number) as yingfu 
(select sum(CostPrice*Number) from OrderDetail where SupplierId<=a.SupplierId)as 成本总价,
(select sum(SalePrice*Number) from OrderDetail where SupplierId<=a.SupplierId)as 销售总价,
from SupplierInfo a,OrderDetail b where b.SupplierId=a.SupplierId group by OrderDetailName,CostPrice,SalePrice,Number,SupplierName

Answer 10

有个逗号位置不对.
你这是累计.
select OrderDetailName,CostPrice,SalePrice,Number ,SupplierName,
sum(SalePrice*Number) as yingshou,sum(CostPrice*Number) as yingfu,
(select sum(CostPrice*Number) from OrderDetail where SupplierId<=a.SupplierId)as 成本总价,
(select sum(SalePrice*Number) from OrderDetail where SupplierId<=a.SupplierId)as 销售总价
from SupplierInfo a,OrderDetail b where b.SupplierId=a.SupplierId group by OrderDetailName,CostPrice,SalePrice,Number,SupplierName