select a.billID,a.weight,a.re,sum(a.Freight) as TOtalFreight
from 表a a,表b b
where a.BillID=a.Billid
group by a.billid,a.weight,a.re
from 表a a,表b b
where a.BillID=a.Billid
group by a.billid,a.weight,a.re
解决方案 »
- 存储过程里 传入参数字符串变量包含 单引号 insert 报错 ?
- 请教nocount的详解
- 会员系统在sqlserver网络不通畅时大家都怎样处理,本地access存储再同步如何?
- 关于SQl中碰到的一个难点 高手进
- 关于SQL日志的问题
- 怎么读到两个表的内容呢?两个表的字段是一样的。
- 给定一个日期,怎样确认是本月的第几周?
- 有新闻表 栏目表,现在查询新闻标题,要获得每个栏目里跟关键词相关的新闻数量???
- 各位高手,帮忙一下,完全复制数据库的问题?急!
- 还是关于存储过程与text类型之间关系的问题
- 邹大哥:查询不固定记录总数如何实现???????????????
- 如何使用sql server客户端工具去连接sqlserver服务器?
Weight=max(a.Weight),
Re=max(a.Re),
TotalFreight=sum(Freight)
from 表A a inner join 表B b
on a.BillID=b.BillID
group by BillID
(select sum(Freight) from 表B where BillID = A.BillID ) AS Freight
from 表A
insert @tab1 values(2,3,'')
declare @tab2 table(BillID int,Freight int)insert @tab2 values(1,2)
insert @tab2 values(1,5)
insert @tab2 values(2,3)select a.BillID,a.Weight,a.Re ,TotalFreight=sum(b.Freight) from @tab1 a left join @tab2 b
on a.BillID=b.BillID
group by a.BillID,a.Weight,a.Re
(BillID int, Weight int, Re varchar(10))
insert a
select'1' ,'1' ,'gfds'
union all
select'2' ,'3' ,'' create table b
(BillID int, Freight int)
insert b
select'1' ,'2'
union all
select '1' ,'5'
union all
select'2' ,'3'select a.billid,a.weight,re,totalfreight=sum(freight)
from a left join b
on a.billid=b.billid
group by a.billid,a.weight,re
from 表a a join 表b b on a.BillID=a.Billid
group by a.*
A.*,TotalFreight=isnull(sum(B.Freight),0)
from
A
left join
B
on
A.BillID=B.BillID
group by
A.BillID,A.Weight,A.Re
order by
A.BillID