
/* Code Fragment 9.9 Give the change history for projectios having a type of 12 or 18 ? */

SELECT PROJECTION_ID, PROJECTION_TYPE, Start_Date, Stop_Date
FROM P_TT
WHERE PROJECTION_TYPE = 12

UNION

SELECT PROJECTION_ID, PROJECTION_TYPE, Start_Date, Stop_Date
FROM P_TT
WHERE PROJECTION_TYPE = 18
