SQL statement problems, associated queries, one-to-many

SQL statement problems, associated queries, one-to-multiple tables for teachers and students, one teacher corresponds to multiple students. I want to find out the students 1, 2, 3, and 4, 5, and 6 corresponding to teacher.

Reply to discussion (solution)

Select * from student Table a, instructor Table B, instructor student relationship Table c where a. studentid = c. studentid and B. teacherid = teacherid and B. teacherid = the instructor id you want to query

What is the table structure?
Table teacher
Id name
1
2 B

Table student
Id tid
1 1
2 1
3 1
4 2
5 2
6 2

Student
Select * from student where tid = 1;

Student B
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 instructor has an ID to query all students that meet this ID condition...