2.查询某教员所带班级的名字.sql

guan yu pai ke xi tong de ruan jian

select [name], Teachings.classcode
from Teachings
inner join Teachers
on (Teachings.TeacherId = Teachers.TeacherId and [name] = '张德全')
INNER JOIN Classes
ON (Teachings.ClassCode = Classes.ClassCode)
WHERE Classes.SectionCode <> 'S1' AND TypeCode = 'T'
group by [name], Teachings.classcode