请问这个用sql查询语句怎么写？

来源：百度知道 编辑：UC知道 时间：2024/05/14 16:22:55
根据ExtTrainteacherPlan表中OldtrainerName,到 personnel表中查对应的部门ID，根据这个ID到department表中查找对应的departmentName

SELECT departmentName from department where id in( select id from personnel where Oldtrainername in(select OldtrainerName from ExtTrainteacherPlan ) )

select
dep.departmentName FROM ExtTrainteacherPlan ext
left join personnel per on (ext.OldtrainerName=per.对应列名)
left join department dep on (per.ID=c.对应列名)

试试

SELECT C.departmentName FROM ExtTrainteacherPlan A JOIN personnel B ON (A.关联列=B.关联列) JOIN department C ON (B.ID=C.关联列)