I have a question about selecting data from three tables the first table is like that:Timetable
ClassID teacherID assistantID
1 1 2
0
2 3 4
Class
table:
classID classname
0 Break
1 MATH
2 ART
teacher
table
teacherID teacherName
1 Tom
2 Lily
3 Rose
4 Nile
I want to produce a table like this Timetable
:
ClassName TeacherName AssistantName
Math Tom Liky
Break
Art Rose Nile
Aucun commentaire:
Enregistrer un commentaire