Question

如何用sql将两个字段的值合并起来赋给其中的一个值？

表B：
column1 column2
a1 b1
a2 b2
a3 b3
a4 b4

表C：
column1 column2
a1 c1
a2 c2
a3 c3
a4 c4

要求更改表B为：
column1 column2
a1 c1.b1
a2 c2.b2
a3 c3.b3
a4 c4.b4

Answer 1

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
)

Answer 2

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

Answer 3

你用的是SQL Server还是Oracle?