select salaries.*, dept_manager.dept_no from salaries
join dept_manager
on sararies.emp_no=dept_manager.emp_no
where sararies.to_date='9999-01-0139;
and dept_manager.to_date='9999-01-0139;
哪位大佬帮忙看看哪里错了
join dept_manager
on sararies.emp_no=dept_manager.emp_no
where sararies.to_date='9999-01-0139;
and dept_manager.to_date='9999-01-0139;
哪位大佬帮忙看看哪里错了
「求助大佬帮看看这道算法题吧!」查找各个部门当前(to_date='9999-01-01')领导当前薪水详情以及其对应部门编号dept_noCREATE TABLE `dept_manager` (`dept_no` char(4)...
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2FquestionTerminal%2Fc63c5b54d86e4c6d880e4834bfd70c3b
全部评论
相关推荐