有奖金的员工相关信息

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'
;