This is my table dataset:
col1 col2 col3 col4
2 7 5 3
11 18 31 7
Those are id's and need to use them as id to grab the name at them associated. if i do:
select table1.name from table1,table2 where table2.id = 1
Gives me the name associated to id 1. I want to automatically grab the names based on the id's in my table in this form.
name1 name2 name3 name4
name_id2 name_id7 name_id5 name_id3
There is a way to obtain this?
---------AS ASKED EXAMPLE
Table1:
col2 col3 col4
2 3 4
2 5 6
Table2:
nome id
all 1
dis1 2
dis3 3
dis4 4
dis5 5
dis6 6
My_result:
col2 col3 col4
dis2 dis3 dis4
dis2 dis5 dis6
Try this code:
SELECT T2_1.nome as col2, T2_2.nome as col3, T2_3.nome as col4
FROM Table1
LEFT JOIN Table2 as T2_1 on T2_1.ID=Table1.col2
LEFT JOIN Table2 as T2_2 on T2_2.ID=Table1.col3
LEFT JOIN Table2 as T2_3 on T2_3.ID=Table1.col4
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments