sql语句update通过另外的表更新本表数据为何不行啊？？？

[xxxuan]

sql语句update通过另外的表更新本表数据为何不行啊？？？：
update s set s.qty=s.qty+b.qty
from stock s,person b
where s.per_no=b.per_no
and b.per_no='02';

[vber1010]

update stock s set s.qty=s.qty+(select qty from person b where s.per_no=b.per_no
and b.per_no='02';)

[linsen_519]

关联表不能这么改

你可以尝试 在外键里面再加一行新的内容（你想改成什么）
然后把子表里面的内容更新，再把外键的旧信息删除

[duqiangcise]

[Quote=引用 1 楼 vber1010 的回复:]
update stock s set s.qty=s.qty+(select qty from person b where s.per_no=b.per_no
and b.per_no='02';)
[/Quote]

+1

[心中的彩虹]

[Quote=引用楼主 xxxuan 的回复:]
sql语句update通过另外的表更新本表数据为何不行啊？？？：
update s set s.qty=s.qty+b.qty
from stock s,person b
where s.per_no=b.per_no
and b.per_no='02';
[/Quote]

update stock s set qty=qty+(select qty from person where s.per_no=per_no and per_no='02')

merge into stock s using person b on(s.per_no=b.per_no and b.per_no='02')
when matched then update set s.qty=s.qty+b.qty

[fxianxian]

sql server的写法跟oracle的写法不一样啊

[Adebayor]

[Quote=引用楼主 xxxuan 的回复:]
sql语句update通过另外的表更新本表数据为何不行啊？？？：
update s set s.qty=s.qty+b.qty
from stock s,person b
where s.per_no=b.per_no
and b.per_no='02';
[/Quote]
表连接条件没有关联上