请老师帮忙看下这样写OK不?谢谢!
来源:4-6 数据操作语言:表连接查询(三)
大东2022
2022-03-17 16:54:36
# 查询每名员工的编号,姓名,部门,月薪,工资等级,工龄,上司编号,上司姓名,上司部门? SELECT h.empno,h.ename,h.deptno,h.dname,h.monthSal,h.grade,h.workAge,h.mgr,i.ename AS mEame,i.deptno AS mDeptno FROM (SELECT l.empno,l.ename,l.deptno,l.dname,l.monthSal,g.grade,l.workAge,l.mgr FROM(SELECT e.empno,e.ename,d.deptno,d.dname,(e.sal + IFNULL(e.comm,0))AS monthSal, FLOOR(DATEDIFF(NOW(),e.hiredate)/365) AS workAge, e.mgr FROM t_emp e LEFT JOIN t_dept d ON e.deptno = d.deptno) l LEFT JOIN (SELECT e1.empno,s.grade FROM t_emp e1 LEFT JOIN t_salgrade s ON e1.sal + IFNUll(e1.comm,0) BETWEEN s.losal AND s.hisal ) g ON l.empno = g.empno) h LEFT JOIN (SELECt e2.empno,e2.ename,d1.deptno FROM t_emp e2 LEFT JOIN t_dept d1 ON e2.deptno = d1.deptno ) i ON h.mgr = i.empno;
1回答
同学你好,也是可以的,继续加油呐
祝学习愉快~
相似问题
回答 2
回答 1