MySQL joins in the same field

[Anon]

Althoug I am working with MySQL, I guess this could apply to other dbs as well.

Supposed you have a users table with unique user id and user name.

The second table has 4 fields:
question, answer, question_user_id, answer_user_id

I can get the name of the user who posted the question, (exclusive)or the user who posted the answer with a join.

Is there a way to get both names in the same query, or would I have to do a second query to get the other name?

Thanks

[[deleted]]

You can JOIN to the same table more than once by using an alias:

SELECT answerpeople.name, questionpeople.name
FROM people AS questionpeople1, people AS answerpeople, questions
WHERE questions.question_user_id = questionpeople.userid
AND questions.answer_user_id = answerpeople.userid

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/