dimanche 24 juillet 2016

How to insert two columns of two tables into one column of other table

Hi I am having trouble joining 3 tables

table1(id1,name_1)

Table2(id2,top,name_2,fk_id1)

table3(id3,top,name_3,fk_id1)

and as a result i want o have:

tableResult(id1,name_1,top,name_2,name_3)

ps: top contain data from table2.top and table3.top

Aucun commentaire:

Enregistrer un commentaire