LaundroMat
Programmer
Hi,
Suppose I have these tables:
How can I do a SELECT on the faq table, and get the authors of the question and of the answer out of the user table?
This (naturally) doesn't work, but it gives an idea of what I'm trying to do:
Thanks in advance.
Suppose I have these tables:
Code:
user: id, name
faq: id, question, answer, q_author, a_author
This (naturally) doesn't work, but it gives an idea of what I'm trying to do:
Code:
SELECT question, answer, name as qname, name as aname
FROM faq, user
WHERE user.id = faq.q_author
AND user.id = faq.a_author
Thanks in advance.