php - 使用单独的 where 子句连接 3 个表

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 6 年前。

Improve this question

我有 3 张 table :

USERS(id, username, email, password)

QUESTIONS(id, uid, type, ques, date, time)

ANSWERS(id, a_uid, qid, reply, a_date, a_time)

我想从所有三个表中选择*

where $_SESSION[‘id’] = questions.uid

& users.id = questions.uid

& questions.id = answers.qid

我怎样才能实现这个目标？

Answer 1

 select * 
 from USERS
 inner join QUESTIONS  on users.id = questions.userid
 inner join ANSWERS on questions.id = answers.qid
 where  questions.uid = $_SESSION['id'] ;