如何指量更新 jbzsrtab表有字段zxs,zsl,zrq,s_xszb表有字段qo,qtl,rq我现在要将qo的和全部更新到zxs里,而且rq与zrq必须如何写是一一对应的, 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 UPDATE A SET zxs = B.qoFROM jbzsrtab AS A JOIN ( SELECT SUM(qo) AS qo,rq FROM s_xszb GROUP BY rq ) AS BON A.zrq = B.rq update jbzsrtabset zxs=qofrom s_xszbwhere zrq=rq update jbzsrtab set zxs=isnull((select sum(qo) from s_xszb where rq=jbzsrtab.zrq),0) 漏了条件,修改一下。update a set a.zxs=b.qofrom jbzsrtab a join (select rq,sum(qo) qo from s_xszb group by rq)b on a.rq=b.zrq UPDATE jbzsrtab SET ZXS=T.QO FROM jbzsrtab T1 ,(SELECT SUM(QO)QO,RQ FROM s_xszb GROUP BY RQ) AS T WHERE T.RQ=T1.zrq update a set a.zxs=b.qofrom jbzsrtab ajoin (select rq,sum(qo) qo from s_xszb group by rq)bon a.rq=b.zrq 语句还原问题 如何在一张表根据条件查出10条记录,然后马上把这10条记录的一个字段值更新 要编一个图片管理的程序,大家给点意见 一个菜菜问题,关于‘自身连接’的理解问题,请各位大大帮我解释解释 SQLSERVE2005作业活动监视 SQL2005 中如何查一个字符串在那些表中 sql启动不了 17311: SQL Server 将终止。发生了严重的异常 c0000005。 大虾们:100分急求sql server数据复制解决方法!!!!!! sql server 2000 无法远程访问 group by的问题 表一包含..... 帮忙看一下这个sql的错误 删除数据
zxs = B.qo
FROM jbzsrtab AS A
JOIN (
SELECT SUM(qo) AS qo,rq FROM s_xszb GROUP BY rq
) AS B
ON A.zrq = B.rq
set zxs=qo
from s_xszb
where zrq=rq
zxs=isnull((select sum(qo) from s_xszb where rq=jbzsrtab.zrq),0)
a.zxs=b.qo
from jbzsrtab a
join (select rq,sum(qo) qo from s_xszb group by rq)b
on a.rq=b.zrq
FROM
jbzsrtab T1 ,(SELECT SUM(QO)QO,RQ FROM s_xszb GROUP BY RQ) AS T
WHERE T.RQ=T1.zrq
a
set
a.zxs=b.qo
from
jbzsrtab a
join
(select rq,sum(qo) qo from s_xszb group by rq)b
on
a.rq=b.zrq