To get such output, just run the code in your phpmyadmin below: Select QUIZ . parent_nid , EXAM . title , SU . name AS SUBJECT , ND . NID , ND . title , FVB . Body_value , GROUP_CONCAT ( MCA . answer , ' ; ' ) AS OPTIONS , ANS . field_answer_value AS ANSWER from `node` as ND Inner join `quiz_multichoice_answers` as MCA on MCA . Question_NID = ND . NID AND MCA . question_vid = ND . VID Inner join `field_revision_body` as FVB on FVB . entity_ID = ND . NID AND FVB . revision_id = ND . VID AND FVB . Entity_type = "Node" Inner join `field_data_field_subject` AS SUB on SUB . entity_id = ND . NID AND SUB . revision_id = ND . VID Inner join `taxonomy_term_data` AS SU on SU . tid = SUB . field_subject_tid Inner join `field_data_field_answer` AS ANS on ANS . entity_id = ND . NID AND ANS . revision_id = ND . VID Inner join `quiz_node_relationship` AS QUIZ on QUIZ . child_nid = MCA . Question_NID Inner join `node` AS EX