sql update multiple values to one column from another table

Question

I have two tables.

table_a table_b

idA idB nameA nameB remarkA1 remarkB remarkA2

Update from Comment: Code I have tired

UPDATE table_b 
SET remarkB = table_a.remarkA1 
FROM table_a WHERE table_b.id = table_a.id

But this code I can only update one value to column remarkB,If i want update values in table_b from table_a by update values from remarkA1, remarkA2 to remarkB How should I write?

Does both the tables have any connection? How are the two tables linked to each other? Any query which you have tried? — G one, Jul 05 '17 at 03:42
@Gone the table don't have connection. I tired yo update by UPDATE table_b SET remarkB = table_a. remarkA1 FROM table_a WHERE table_b.id = table_a.id But this code i can update one value to column remarkB, if I want remarkB have two value from remarkA1 , remarkA2 . I can write or not? — Bear_Seul, Jul 05 '17 at 04:18

score 0 · Accepted Answer · answered Jul 05 '17 at 04:17

0

You can use the following Update Statement along with you need a string CONCAT

I'm assuming the data type of table_a.remarkA1 and table_a.remarkA2 are string (i.e., VARCHAR)

UPDATE table_b
SET remarkB = CONCAT(table_a.remarkA1, ' ', table_a.remarkA2)
FROM table_a
WHERE table_b.idB = table_a.idA

answered Jul 05 '17 at 04:17

B.Balamanigandan

4,713
11
68
130

Thank you,but i use SQL server 2008 r2. It's can't use concat .What can i do ? – Bear_Seul Jul 05 '17 at 05:06
@Bear_Seul - you can try `SELECT {fn concat (table_a.remarkA1, table_a.remarkA2)};` in previous versions. Only accepts 2 parameters though – B.Balamanigandan Jul 05 '17 at 05:59
use `table_a.remarkA1 + ' ' + table_a.remarkA2` in part of the CONCAT – Ikyong Jul 05 '17 at 06:53

sql update multiple values to one column from another table

1 Answers1