sql 求和 嵌套查询

Question

两张表，想求出对应字段的总价。。。比如说是“M”。。。M的总价格应该是（2+3）*2。8。。。想问一下SQL语句怎么写，谢谢

Answer 1

select a.child_id, sum(b.num)*a.price
from Base a,BOM b
where a.child_id = b.child_id
group by a.child_id,a.price
--已经测试了,如果还有什么问题 可以追问!

Answer 2

select a.child_id,a.price*b.num from base a,(select child_id,sum(num) num from bom group by child_id) b where a.child_id=b.child_id

Answer 3

with a1 as (
select a.child_id ,price,num
from base as a left join bom as b on a.child_id=b.child_id
)
select sum(num*price) from a1 group by child_id

Answer 4

select a.child_id,M=a.N*b.Price
from (
select child_id,sum(num)as N from bom
group by child_id)a left join base b on a.child_id=b.child_id

Answer 5

select b.Child_Id,sum(Num*Price) zJ from Base a,BOM b
where a.Child_Id=b.Child_Id
group by b.Child_Id本回答被提问者和网友采纳