melo Posted March 17, 2013 Share Posted March 17, 2013 Can anyone help me on how will I join my three tables? I have this. table name: tbl_multiplechoice questionId choice_A choice_B choice_C choice_D correct_answer table name: tbl_tof questionId correct_answer table name: tbl_idef questionId correct_answer what I want to do is to JOIN them so that I can compare the user's answer from the correct_answer of those tables. I tried UNION and UNION ALL but failed. Only the table of multiple choice is selecting. It would be a great help! thanks. I already post this topic but in a wrong category so I am posting it here now. Link to comment https://forums.phpfreaks.com/topic/275785-how-to-join-tables/ Share on other sites More sharing options...
DaveyK Posted March 18, 2013 Share Posted March 18, 2013 what is the difference between the tbl_tof and tbl_def table? Link to comment https://forums.phpfreaks.com/topic/275785-how-to-join-tables/#findComment-1419322 Share on other sites More sharing options...
Barand Posted March 18, 2013 Share Posted March 18, 2013 ... and what are the differences between the "correct_answer" fields that appear everywhere? Link to comment https://forums.phpfreaks.com/topic/275785-how-to-join-tables/#findComment-1419419 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.