CREATE TABLE TableData_400 (id INT, created_date DATETIME, sample_1 TEXT, sample_2 TEXT, sample_3 TEXT, sample_4 TEXT, sample_7 TEXT, sample_8_1 text, sample_8_2 text, sample_9 smallint , sample_10 smallint ); INSERT INTO TableData_400 VALUES ('1','2019-05-17 06:19:13','aaa', 'bbb','ccc','ddd','eee','fff','ggg',0,0); select * from TableData_400

CREATE TABLE TableData_elements (Dataid INT, sample_id INT, sample_title TEXT ); INSERT INTO TableData_elements VALUES ('400','1','Fname'), ('400','2','Sname'), ('400','3','Lname'), ('400','4','sample'), ('400','7','sample1'), ('400','8','Name'), ('400','9','checkbox'), ('400','10','checkbox'); select * from TableData_elements where Dataid=400

CREATE TABLE TableData_elements_options (Dataid INT, sample_id INT, option_id INT, optionss TEXT ); INSERT INTO TableData_elements_options VALUES ('400',9,1,'First'), ('400',9,2,'second'), ('400',9,3,'Third'), ('400',10,1,'First'), ('400',10,2,'second'), ('400',10,3,'Third'); select * from TableData_elements_options where Dataid=400

SELECT CONCAT( 'SELECT ', GROUP_CONCAT(CONCAT('sample_', sample_id, ' ', sample_title)), ' FROM TableData_400' ) INTO @sql FROM TableData_elements; SELECT @sql; PREPARE myStatement FROM @sql; EXECUTE myStatement ; DROP PREPARE myStatement;

SELECT CONCAT( 'SELECT ', GROUP_CONCAT(CONCAT('sample_', te.sample_id, CASE WHEN teo.option_id>0 THEN CONCAT('_',teo.option_id) ELSE '' END, ' ', sample_title)), ' FROM TableData' ) FROM TableData_elements te LEFT JOIN TableData_elements_options teo ON teo.Dataid=te.Dataid AND teo.sample_id=te.sample_id ;

expected result will be like this , if (sample title= check box then no need to select value from options table) SELECT sample_9 'checkbox',sample_10 'checkbox',sample_1 'Fname',sample_2 'Sname',sample_3 'Lname',sample_4 'sample',sample_7 'sample1',sample_8_1 'FName',sample_8_2 'Sname' (if sample title=name take fname and seconad name as _1,_2) FROM TableData