SYBABE关联更新问题
有表A:
AUTOIDCOUNTSUM
1
2
3
表B:
AUTOID...
1...
1...
2...
3 ...
表A中的AUTOID和表B中的AUTOID是相等的,现在要把表B中的每个AUTOID的行数更新到表A的COUNTSUM中,在MS SQL中可以这么写,UPDATE A SET COUNTSUM=T.COUNTSUN FROM (SELECT AUTOID,COUNT(*) AS COUNTSUM FROM B GROUP BY AUTOID) AS T。但是SYBASE不能这么写,该怎么写呢?
[解决办法]
sybase版本
update a from a inner join
(SELECT AUTOID,COUNT(*) AS COUNTSUM FROM B GROUP BY AUTOID) AS T
on a.AUTOID=t.AUTOID set
a.COUNTSUM=T.COUNTSUm
[解决办法]
updatet a
set COUNTSUM=(select count(*) from b where AUTOID=a.AUTOID)