有奖金的员工相关信息
获取有奖金的员工相关信息。
http://www.nowcoder.com/questionTerminal/5cdbf1dcbe8d4c689020b6b2743820bf
select e.emp_no ,e.first_name , e.last_name , eb.btype , s.salary , (s.salaryeb.btype0.1) bonus
from employees e , emp_bonus eb ,salaries s
where e.emp_no = eb.emp_no
and e.emp_no=s.emp_no
and eb.btype is not null
and s.to_date='9999-01-01'
;
sql里可以写 但是sqllite不可以 ：
select e.emp_no ,e.first_name , e.last_name , eb.btype , s.salary , (s.salaryeb.btype0.1) bonus
from employees e , emp_bonus eb ,salaries s
where e.emp_no = eb.emp_no =s.emp_no
and eb.btype is not null
and s.to_date='9999-01-01'
;
