Query to get job title of staff or null if staff not assign a job-title:
SELECT CORE_Staff.ID, CORE_Staff.JobTitleID, CORE_JobTitle.Name
FROM CORE_Staff LEFT JOIN CORE_JobTitle
ON CORE_JobTitle.ID = CORE_Staff.JobTitleID
where (CORE_JobTitle.Name='Driver') or (CORE_JobTitle.Name is null)