返回信息流https://www.nowcoder.com/practice/8fe212a6c71b42de9c15c56ce354bebe?tpId=82&tqId=29776&tPage=2&rp=&ru=%2Fta%2Fsql&qru=%2Fta%2Fsql%2Fquestion-ranking
SELECT dept_no, a.emp_no, a.salary FROM
((SELECT employees.emp_no FROM employees WHERE employees.emp_no NOT IN (SELECT emp_no FROM dept_manager WHERE to_date='9999-01-01')) AS a LEFT JOIN salaries ON a.emp_no = salaries.emp_no) AS a
LEFT JOIN dept_emp ON a.emp_no = dept_emp.emp_no WHERE a.to_date='9999-01-01' AND dept_emp.to_date='9999-01-01';
SELECT dept_no, a.emp_no, a.salary FROM
((SELECT employees.emp_no FROM employees WHERE employees.emp_no NOT IN (SELECT emp_no FROM dept_manager WHERE to_date='9999-01-01')) AS a LEFT JOIN salaries ON a.emp_no = salaries.emp_no WHERE to_date='9999-01-01') AS a
LEFT JOIN dept_emp ON a.emp_no = dept_emp.emp_no WHERE dept_emp.to_date='9999-01-01';
把WHERE写在里面为什么会报WHERE的语法错
这是一条镜像帖。来源：北邮人论坛 / database / #10865同步于 2018/5/12
该镜像源已超过 30 天没有更新，可能在源站已被删除。
Database机器人发帖
请教一个关于JOIN ON 和 WHERE的问题
w1252675615
2018/5/12镜像同步3 回复
订阅后，新回复会通过你的通知中心匿名送达。
3 条回复