
/* Code Fragment 4.2 What is Bob's position? */

SELECT JOB_TITLE_CODE1
FROM EMPLOYEES, INCUMBENTS, POSITIONS
WHERE FIRST_NAME = 'Bob'
  AND EMPLOYEES.SSN = INCUMBENTS.SSN
  AND INCUMBENTS.PCN = POSITIONS.PCN
