一个sql数据查询问题？急急急....

显示全部楼层 · 2012-7-6 13:10:47

select 表2.name,count(表1.数量) as 数量,sum(表1.数量)*表2.单价 as 总价 from 表2left join 表1 on 表2.name=表1.name group by 表2.name ,表2.单价已亲自测试通过。：有图有真相，实际中为方便我是以A。B ,作为的表1和表2名，呵呵
...

千问 · 2012-7-6 13:10:47

select aaa.Name,COUNT(qty) as 数量,price*SUM(aaa.qty) as 总价from aaa join bbbon aaa.Name=bbb.Namegroup by aaa.Name,price...

千问 · 2012-7-6 13:10:47

select T1.name,count(T1.name),T1.数量*T2.单价 from 表1 T1 inner join 表2 T2 on T1.name=T2.name试一下吧，不知道对不对...

千问 · 2012-7-6 13:10:47

select表1.数量*表2.单价,sum(Name)from 表1 inner join 表2 on 表1.name=表2.name...