SELECT 
AL3.INST_NAME, 
AL4.NSF_FIELD_CATEGORY, 
AL4.NSF_FIELD_NAME, 
AL5.FINANCE_TYPE, 
AL1.EXPENDITURE_AMOUNT 
FROM WAREUSER.NSF_RDEXP_EQUIPMENT_DETAIL AL1, 
     WAREUSER.FISCAL_YEAR AL2, 
     WAREUSER.INSTITUTION AL3, 
     WAREUSER.NSF_RDEXP_FIELD AL4, 
     WAREUSER.NSF_RDEXP_FINANCE_TYPE AL5 
WHERE 
(AL1.FISCAL_YEAR_KEY=AL2.FISCAL_YEAR_KEY 
 AND AL3.INSTITUTION_KEY=AL1.INSTITUTION_KEY 
 AND AL1.NSF_RDEXP_FIELD_KEY=AL4.NSF_RDEXP_FIELD_KEY 
 AND AL1.NSF_RDEXP_FINANCE_TYPE_KEY=AL5.NSF_RDEXP_FINANCE_TYPE_KEY)  
AND 
(AL2.FISCAL_YEAR='2000' 
 AND AL3.INST_NAME='Arizona' 
 AND AL5.FINANCE_TYPE IN ('Federally Financed', 'Non Federally Financed') 
 AND AL4.NSF_FIELD_NAME IN ('Computer Sciences', 'Engineering', 
                           'Environmental Sciences', 'Life Sciences', 
                           'Mathematical Sciences', 'Other Sciences', 
                           'Physical Sciences', 'Psychology', 'Social Sciences')
)