create new field with information of some fields in another table related to the first one.

[jennv]

i want to create a new field in a table which will contain some informations from another table. example: 

table 1

id column1 column2 

1  test          test

2  test          test

table 2

id  id_table1 description  price

1       1             test123      10

2       1             test456      15

3       2             test789      17

Result :

table 1

id column1   column2    NewColumn

1  test             test           test123, 10 ;  test456, 15

2  test             test           test789, 17

I hope i was clear. thank you!

[jennv · Accepted solution]

i did it using a BR