I am trying to join three tables of users, scores, scores2 of same database in mysql. I need output table like these columns from three tables id, name, rollnumber, phonenumber, right_answer, right_answer2. I tried query like this SELECT users.id, users.name, users.rollnumber, users.phonenumber, scores.right_answer, scores.right_answer2 FROM users, scores, scores2 WHERE users.id = scores.user_id OR users.id = scores2.user_id
But I got output in two rows, how can I fix this, please help me.
No responses yet.