Home >Backend Development >PHP Tutorial >SQL语句有关问题，关联查询，一对多
SQL语句有关问题，关联查询，一对多
- WBOYOriginal
- 2016-06-13 12:09:041170browse
SQL语句问题，关联查询，一对多
比如老师和学生表，一个老师对应多个学生。想查出来老师A和他对应的学生1，2，3，老师B和他对应的4,5,6.
------解决思路----------------------
<br /><br />select * from 学生表 a,教师表 b,教师学生关系表 c where a.studentid = c.studentid and b.teacherid = teacherid and b.teacherid = 你要查的老师id<br /><br />
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：二维码解析后文字乱码,该怎么处理Next article：php将图文稿件保存在text字段里好还是将生成一个html文件还是其他办法