-- -----------------------------------------------
-- USING SQL TO DEVELOP TIME ORIENTED APPLICATIONS
-- By : Richard T. Snodgrass
-- -----------------------------------------------
--
-- What is Bob's Position?
-- By   : Bruce C. Huang
-- Date : Dec. 12, 1997
-- POSITIONS and INCUMBENTS are non-temporal
-- -----------------------------------------------
REM
REM Code Fragment 5.2 in Oracle 7.3
REM
SELECT JOB_TITLE
FROM   EMPLOYEES, INCUMBENTS, POSITIONS, JOB_TITLES
WHERE  FIRST_NAME    = 'Bob'
   AND EMPLOYEES.SSN = INCUMBENTS.SSN
   AND INCUMBENTS.PCN= POSITIONS.PCN
   AND POSITIONS.JOB_TITLE_CODE1 = JOB_TITLES.JOB_TITLE_CODE;
