SELECT AL2.ACADEMIC_YEAR, 
AL2.AAUDE_INST_CODE, 
AL2.UNIT_ID, 
AL2.INSTITUTION_NAME, 
AL3.GRADUATE_STUDENT_TYPE, 
AL3.GRADUATE_STUDENT_TYPE_CODE, 
AL4.CIP_PROGRAM_CODE, 
AL4.CIP_TYPE, 
AL4.PROGRAM_DEPARTMENT_NAME, 
AL5.CIP_PROGRAM_TITLE, 
AL5.CIP_CATEGORY_CODE, 
AL5.CIP_CATEGORY_TITLE, 
AL5.CIP_FOUR_DIGIT_CODE, 
AL5.CIP_FOUR_DIGIT_TITLE, 
AL1.MINIMUM_SALARY, 
AL1.MAXIMUM_SALARY, 
AL1.AVERAGE_SALARY, 
AL1.NUMBER_OF_FTE, 
AL1.HEAD_COUNT, 
AL1.FIRST_YEAR_AVERAGE_SALARY, 
AL1.FIRST_YEAR_HEAD_COUNT, 
AL1.FIRST_YEAR_FTE 
FROM WAREUSER.GRADSTIP_BY_CIP_DETAIL AL1, 
     WAREUSER.GRADSTIP_INSTITUTION AL2, 
     WAREUSER.GRADSTIP_STUDENT_TYPE AL3, 
     WAREUSER.GRADSTIP_CIP_TYPE AL4,
     WAREUSER.CIP AL5 
WHERE AL2.GRADSTIP_INSTITUTION_KEY=AL1.GRADSTIP_INSTITUTION_KEY 
AND   AL4.GRADSTIP_CIP_TYPE_KEY=AL1.GRADSTIP_CIP_TYPE_KEY 
AND   AL3.GRADSTIP_STUDENT_TYPE_KEY=AL1.GRADSTIP_STUDENT_TYPE_KEY 
AND   AL5.CIP_KEY=AL1.CIP_KEY  
AND   AL2.ACADEMIC_YEAR='2006-2007'