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

Closed. This question needs details or clarity。它当前不接受答案。
                            
                        
                    
                
                            
                                
                
                        
                            
                        
                    
                        
                            想改善这个问题吗？添加详细信息并通过editing this post阐明问题。
                        
                        3年前关闭。
                                                                                            
                
        
我有3张桌子：

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

我怎样才能做到这一点？

最佳答案

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

关于php - 用单独的where子句连接3个表，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/38936944/