create table aaa
(a char(2),
b int )
go
create table bbb
(a char(2),
b int )
go
create table ccc
(a char(2),
b int )
go
insert into aaa values('a',1)
insert into bbb values('a',2)
insert into ccc values('a',3)
insert into aaa values('b',4)
insert into bbb values('b',5)
insert into ccc values('b',6)求,想实现,AAA.B = BBB.B+CCC.B 怎么写
(a char(2),
b int )
go
create table bbb
(a char(2),
b int )
go
create table ccc
(a char(2),
b int )
go
insert into aaa values('a',1)
insert into bbb values('a',2)
insert into ccc values('a',3)
insert into aaa values('b',4)
insert into bbb values('b',5)
insert into ccc values('b',6)求,想实现,AAA.B = BBB.B+CCC.B 怎么写
SET B = BBB.B + CCC.B
FROM AAA
INNER JOIN BBB
ON AAA.A = BBB.A
INNER JOIN CCC
ON AAA.A = CCC.A
select b.b + c.b from bbb b,ccc c where b.a = c.a替换
update aaa
set b = b.b + c.b
from aaa a , bbb b, ccc c
where a.a = b.a and a.a = c.a
(a char(2),
b int )
go
create table bbb
(a char(2),
b int )
go
create table ccc
(a char(2),
b int )
go
insert into aaa values('a',1)
insert into bbb values('a',2)
insert into ccc values('a',3)
insert into aaa values('b',4)
insert into bbb values('b',100)---这里有两条,可以实现SUM后,再相加吗?
insert into bbb values('b',100)---这里有两条,可以实现SUM后,再相加吗?
insert into ccc values('b',6)---这里有两条,可以实现SUM后,再相加吗?
insert into ccc values('b',6)---这里有两条,可以实现SUM后,再相加吗?