--这样就可以了-----------------------------update a set xse=b.xse from tbla a join (select bmbh,sum(xse) xse from tblb group by bmbh) b on a.bmbh=b.bmbh
update tbla set xse=b.xse from tbla a,(select bmbh, xse=sum(xse) from tblb group by bmbh) b where a.bmbh=b.bmbh
请问楼上两位,该语句支持sybase数据库吗?
我在sybase库中不能执行,请问可以有办法实现吗? 出错: Server Message: Number 156, Severity 15 Server 'sybpszx', Line 2: Incorrect syntax near the keyword 'select'. Server Message: Number 102, Severity 15 Server 'sybpszx', Line 2: Incorrect syntax near ')'.
set xse=b.xse
from tbla a join (select bmbh,sum(xse) xse
from tblb
group by bmbh) b
on a.bmbh=b.bmbh
from tbla a,(select bmbh, xse=sum(xse) from tblb group by bmbh) b
where a.bmbh=b.bmbh
出错:
Server Message: Number 156, Severity 15
Server 'sybpszx', Line 2:
Incorrect syntax near the keyword 'select'.
Server Message: Number 102, Severity 15
Server 'sybpszx', Line 2:
Incorrect syntax near ')'.