根据给出的部门ID查出当前部门和子部门的员工信息,是MVC+EF做的
我是个实习生,不太会
我应该怎么写呢
两个表,没有外键关系
员工:id name Employee_no departmentid
部门:id name parent_id
员工表中departmentid和部门表中name是一样的
用的Lamda的表达式,有没有大佬给我写一个。
select * from Employee where departmentid in(select name from Department where parent_id in
(select departmentid from Employee where departmentid in(select name from Department where parent_id='A0')))
select * from Employee where departmentid in(select name from Department where parent_id='AIC1' or departmentid='A1')
这是我写的SQL,A0是顶级部门,要两次嵌套,A1是次一级,要一次嵌套。
求大佬帮帮忙。
写好可以发我qq邮箱,1633256511@qq.com.不发也行,求解答啊!