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. Quote 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? Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/275785-how-to-join-tables/#findComment-1419419 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.