output of a column in one table to be used a input (column) of another table
select heli_type from heli_tab where heli_no = 'DS1500000000'
heli_type version
------------ -----------
H1 SAY -------------- out put data value is column name of the query below
I want to use that ouput as a column name in another table called heli_tab_det . how to do that using SQL
select H1,qph_say from heli_tab_det
H1 qph_say
---- ------------
1 1
2 5
3 10
Output of a row in one table to be used as a input(column) in another table