Refresh the table using the fields of two other tables, please help me with this

My requirement is to update the description field in table 1 with the description of tables 2 and 3 by concatenation. I will give you the structure below.

table1 --PAD table2 --- PD table3 --- AD

table D with concatenation Table 2 D and table3 D

0
source share
1 answer
INSERT INTO Table1 (Description)
    SELECT CONCAT(t2.Description, t3.Description) FROM Table2 t2, Table3 t3
    ---- optional join here
0
source

Source: https://habr.com/ru/post/1713844/


All Articles