SQL statement issues, correlated queries, one-to-many

For example, the teacher and the student table, a teacher corresponds to several students. Want to find out the teacher A and his corresponding students of the 4,5,6, teacher B and his counterpart.

Reply to discussion (solution)

SELECT * FROM student Table A, teacher Table B, teacher Student relations Table C where A.studentid = C.studentid and B.teacherid = Teacherid and B.teacherid = The teacher ID you want to check

What is the table structure?
Table Teacher
ID Name
1 A
2 B

Table Student
ID TID
1 1
2 1
3 1
4 2
5 2
6 2

A teacher's student
SELECT * from student where tid=1;

B Teacher's students
SELECT * from student where tid=2;

Or select A.*,b.name from student as a left join teacher as B on a.tid = b.id ORDER by A.tid;

The teacher has an ID query for all students who meet this ID condition ...

