select dep_name 部门名称 , (select emp_name from employee where emp_id = dep_manager )总经理名字, (select emp_name from employee where dep_deputy_manager = dep_manager )副总经理名字 from department
//副总经理名字 select employee.emp_name from employee,department where department.emp_id=department.dep_deputy_manager//总经理名字 select employee.emp_name from employee,department where department.emp_id=department.dep_manager
如果是这样的话,Try select dep_name 部门名称 , (select emp_name from employee where emp_id = dep_manager )总经理名字, (select emp_name from employee where dep_deputy_manager = dep_manager )副总经理名字 from department
select 部门名称=a.dep_name,总经理名字=b.emp_name, 副总经理名字=c.emp_name from department a left join employee b on a.dep_manager=b.emp_id left join employee c on a.dep_deputy_manager=c.empid
select dep_name,b.emp_name as 总经理,c.emp_name as 副总经理 from department a left join employee b on a.dep_manager=b.emp_id left join employee c on a.dep_deputy_manager=c.emp_id
--modify select 部门名称=a.dep_name,总经理名字=b.emp_name, 副总经理名字=c.emp_name from department a left join employee b on a.dep_manager=b.emp_id left join employee c on a.dep_deputy_manager=c.emp_id
select dep_name 部门名称 , (select top 1 emp_name from employee B where B.emp_id = A.dep_manager ) as 总经理名字, (select top 1 emp_name from employee C where C.dep_deputy_manager = A.dep_manager ) as 副总经理名字 from department A 这个应该没问题,我经常用这种方式
select employee.emp_name
from employee,department
where department.emp_id=department.dep_deputy_manager//总经理名字
select employee.emp_name
from employee,department
where department.emp_id=department.dep_manager
select dep_name 部门名称 ,
(select emp_name from employee where emp_id = dep_manager )总经理名字,
(select emp_name from employee where dep_deputy_manager = dep_manager )副总经理名字
from department
left join employee b on a.dep_manager=b.emp_id
left join employee c on a.dep_deputy_manager=c.empid
from department a
left join employee b on a.dep_manager=b.emp_id
left join employee c on a.dep_deputy_manager=c.emp_id
select 部门名称=a.dep_name,总经理名字=b.emp_name, 副总经理名字=c.emp_name from department a
left join employee b on a.dep_manager=b.emp_id
left join employee c on a.dep_deputy_manager=c.emp_id
select dep_name 部门名称 ,
(select top 1 emp_name from employee B where B.emp_id = A.dep_manager ) as 总经理名字,
(select top 1 emp_name from employee C where C.dep_deputy_manager = A.dep_manager ) as 副总经理名字
from department A
这个应该没问题,我经常用这种方式