Database: cre_Students_Information_Systems
Question: List the details for all the pairs of teachers and students who are in the same class.
SQL:
SELECT T1.teacher_details ,  T3.student_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id JOIN Students AS T3 ON T2.student_id  =  T3.student_id