SELECT AL5.AAUDE_INST_CODE, 
       AL5.INST_NAME, 
       AL7.CIP_PROGRAM_CODE, 
       AL7.CIP_PROGRAM_TITLE, 
       AL3.SCHOOL_ABBREVIATION, 
       AL3.DEPARTMENT_NAME, 
       AL4.FACULTY_RANK, 
       AL4.TENURE_TYPE, 
       AL4.TRACK_ATTRIBUTE, 
       AL4.FULL_OR_PART_TIME, 
       AL4.MEDICAL_STATUS, 
       AL4.EAP_CATEGORY, 
       AL2.GENDER, 
       AL2.ETHNICITY, 
       AL1.FACULTY_HEAD_COUNT 
FROM WAREUSER.FACULTY_PROFILE_DETAIL AL1, 
     WAREUSER.FACULTY_DEMOGRAPHIC AL2, 
     WAREUSER.FACULTY_PROFILE_DEPT AL3, 
     WAREUSER.FACULTY_PROFILE_TYPE AL4, 
     WAREUSER.INSTITUTION AL5, 
     WAREUSER.ACADEMIC_YEAR AL6, 
     WAREUSER.CIP AL7 
WHERE AL6.ACADEMIC_YEAR_KEY=AL1.ACADEMIC_YEAR_KEY 
AND AL5.INSTITUTION_KEY=AL1.INSTITUTION_KEY 
AND AL3.FACULTY_PROFILE_DEPT_KEY=AL1.FACULTY_PROFILE_DEPT_KEY 
AND AL4.FACULTY_PROFILE_TYPE_KEY=AL1.FACULTY_PROFILE_TYPE_KEY 
AND AL2.FACULTY_DEMOGRAPHIC_KEY=AL1.FACULTY_DEMOGRAPHIC_KEY 
AND AL7.CIP_KEY=AL1.CIP_KEY
AND AL6.ACADEMIC_YEAR='2002-2003' 
AND AL5.INST_NAME='Rutgers'