SQL数据库多条件查询和修改

2025-05-15 17:49:17
推荐回答(2个)
回答1:

update B set B.G=A.G from A inner join B on A.Q=B.Q
where A.W='广州' and A.E='牛肉' and A.R=''

回答2:

upate b
set b.g=a.g
from A a

inner join B b on a.Q=b.Q 其它一样