在线给分 update A set id=sum(*) from B where a.book=bid.bookid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 update a set id=sum(b.number) from a join b on a.bookid=b.bookid insert tableA(id)select B.number from tableB b join tableA a on A.BookID=B.BookID insert tableA(id)select sum(B.number) from tableB b join tableA a on A.BookID=B.BookID update A set id=sum(B.number) from B where a.book=bid.bookid have a try:update a set a.id= c.sum(number) from (select bookid,sum(number) from b group by bookid ) c where A.BookID=c.BookID update a set a.id= c.number from (select bookid,sum(number) number from b group by bookid ) c where A.BookID=c.BookID 求高手看看我的ER图有什么地方不合理 SQL计算逻辑表达式 在SQL Service 2005 中字段名全部使用中文会有多大的影响 动态sql的问题? 怎样统计excel表的列数? 数据库备份时的问题 高分:帮我看看这条语句,解决马上给分! 求一SQL 安装sql2000的问题 更新表中的一个字段,值是本表本记录中,上个月的这个字段值,用一条SQL实现 sql server7.0下如何自动备份? 100分--如何获取SQL sever服务器端的变量(比如:服务器端的时间)?谢谢!
select B.number from tableB b join tableA a on A.BookID=B.BookID
select sum(B.number) from tableB b join tableA a on A.BookID=B.BookID
update a set a.id= c.sum(number) from (select bookid,sum(number) from b group by bookid ) c where A.BookID=c.BookID