update B b1 set column2 = (
select b2.column2 || '.' || c1.column2
from B b2, C c1
where b1.column1 = b2.column1
and b2.column1=c1.column1
)
access:
update b INNER JOIN c on b.column1 = c.column1 set b.column2 = c.column2 & '.' & b.column2
sqlsever:
update b INNER JOIN c on b.column1 = c.column1 set b.column2 = c.column2 + '.' + b.column2
你用的是SQL Server还是Oracle?
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024