Combine value of a column into a single column in other tabl

 

I have two tables in the database as shown in the image...I have to merge all the value of index_name to Constituent_Indices and I have to show data in a single select query...as shown in the below image.Please help me.

 

Thank you in advance