So you had a fundamental problem (join in the wrong place) that you could have demonstrated with 10 - 20 lines of code, and probably have found the problem yourself in the process of generating the sample code. Why would you want to post a ton of cruft just to show that issue (see I know what I mean. Why don't you?)?