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.

1. Column names of users table : id, name, email, password, rollnumber, phonenumber
2. Column names of scores table : id, user_id, category_id1, right_answer, wrong_answer, unanswered
3. Column names of scores2 table : id, user_id, category_id2, right_answer2, wrong_answer, unanswered