Update a table using the fields of the other two table, please help me in this.

Question

My requirement is to update the description field in table 1 with the description of the table 2 and 3 by concatinating. I'll give you the structure below.

table1 --P A D table2 --- P D table3 --- A D

table D with concatinating The table2 D and table3 D

Answer 1

INSERT INTO Table1 (Description)
    SELECT CONCAT(t2.Description, t3.Description) FROM Table2 t2, Table3 t3
    ---- optional join here

Answer 2

Astander and pb - I dont know your name , but very kind of you.

Astander, In the first table i have 3 fields where descr is empty for all the rows as you mentioned above. The other two fields, one is in 2 table and other is for the third table. No common field between these three tables. table1 P A D table2 P D table3 A D.

Pb, I want to update the table1 not to insert.

Thanks for your help in advance.