SQL consulting?

select currentsalary, lastraisedate from salaries a where exists (select * from employees b where employee_id = a.employee_ID and lastname = 'Crosby')