SQLTeam.com | Weblogs | Forums

Big Join Help

Have an enormous join that I'm stuck on. I have the bones of it, but need to add a couple of new fields to the query. I need to add the following fields: 'Improvement' 'LAND_VAL' 'TOT_MAIN_SF' 'DESIRABILITY_RATING' 'FOUNDATION_TYP_DESC'

From the following tables: '16res_detail' '15res_detail' '14res_detail' '13res_detail' they need to be joined onto '16account_info' '15account_info' '14account_info' '13account_info'

This is the current query that all of this has to be added to: