J
john15243
I have 2 tables. One is teachers and the other is students. How can I get a
query to have one line with one teacher's name and the different students
name on the same one line
Ex. Line 1 (TeacherA, Student1, Student2, etc)
Line 2 (TeacherB, Student4, Student 8)
I get this result when I created a query
Line 1 (TeacherA, Student1, Student1)
Line 2 (TeacherA, Student2, Student2)
query to have one line with one teacher's name and the different students
name on the same one line
Ex. Line 1 (TeacherA, Student1, Student2, etc)
Line 2 (TeacherB, Student4, Student 8)
I get this result when I created a query
Line 1 (TeacherA, Student1, Student1)
Line 2 (TeacherA, Student2, Student2)