Hi

Something to bear in mind:

I used an inner join from dbo.MSP_EpmProject_UserView to [MSPCFPRJ_Business Owner_AssociationView] because that's what's in the code above. If [MSPCFPRJ_Business Owner_AssociationView] hasn't got a match for every record in dbo.MSP_EpmProject_UserView & you don't want to lose any data you may need a left outer join instead.