job title code for staff id? | Do you mean all the job title codes for all the staff ids? | yes
SELECT  job_title_code from Staff_Department_Assignments
job title code for each staff id refers to SELECT job_title_code FROM Staff_Department_Assignments;