select
e.emp_no,e.first_name,e.last_name,b.btype,s.salary,s.salaryb.btype0.1 as bonus
from
employees e,emp_bonus b,salaries s
where
s.to_date='9999-01-01'
and e.emp_no=b.emp_no
and b.emp_no=s.emp_no;