SELECT POSITIONS.JOB_TITLE_CODE1
FROM EMPLOYEES, INCUMBENTS, POSITIONS
WHERE EMPLOYEES.FIRST_NAME="Bob"
              AND EMPLOYEES.SSN=INCUMBENTS.SSN
              AND INCUMBENTS.PCN=POSITIONS.PCN
              AND INCUMBENTS.END_DATE=#12/31/9999#;

