Database Inner join For fetching Records
This code will work in tsql- it doesn't even actually require a join between the tables:

    SELECT question_id, 
       MAX(ans_obj_1) AS ans1_obj, 
       MAX(ans_obj_2) AS ans2_obj, 
       MAX(ans_obj_3) AS ans3_obj, 
       MAX(ans_obj_4) AS ans4_obj, 
       MAX(ans_sub) AS answer_subj 
FROM table_2
PIVOT
(MAX(answer_value)
 FOR answer_value IN ([ans_obj_1], [ans_obj_2], [ans_obj_3], [ans_obj_4], [ans_sub])
 ) A
 GROUP BY question_id