vendredi 14 août 2015

Select from three table

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