这是问答表，student_id以及teacher_id对应下面用户表的id
这是用户表
请问我如何获取问答表的同时，如何根据student_id，以及teacher_id直接获取到用户的名称，是怎样的sql语句，一条能写完吗，求解
select a.*,b.name as student_name,c.name as teacher_name
from 问答表
left join 用户表 b on a.student_id=b.id
left join 用户表 c on a.teacher_id=c.id
What are the production methods of html5 animation production?
Three major characteristics of java
jdk environment variable configuration
mstsc remote connection failed
What are the common management systems?
Solution to invalid signature
What are the definitions of arrays?
How to enter root privileges in linux
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
