ANSI SQL inner join

select a.employee_id, a.emp_name, a.department_id,
    b.department_name
from employees a inner join departments b
on a.department_id=b.department_id;