求高手SQL语句,多个表的查询更新语句

显示全部楼层 · 2013-8-22 08:56:41

并不是所有的表A的userid都存在表B和表C吧，那要用临时表做了，假设只有3个表:A,B,C create table #B(Buserid, 按照表B的数据类型Bscore1,BScore2) create table #C(Cuserid, 按照表C的数据类型Cscore1,) select * into #B from Bselect * into #C from C select userid,'0','0' into #B from Awhere #B.userid not in(select userid from A) select user...

千问 · 2013-8-22 08:56:41

--楼主我帮你写吧--有什么疑问可以随时找我希望采纳declare @i dec(12,2) declare @j dec(12,2) select @i=Score from aselect @j=SUM(Score) from (select Score from bunion allselect Score from...

千问 · 2013-8-22 08:56:41

update A set A.isDou=1 from A join B on A.userid=B.useridjoin C on A.userid=C.useridgroup by A.userid having A.score>sum(B.score2-B.score1)+sum(C.score)有问题可以追问哦~~...