Poor Performance with Inner Joins

I am trying to limit the amount of editing I have to do when I update reports to include new periods. There are no date fields in the data sources where I am pulling, so the periods are chosen as a l...