Confirm and check did you follow the below script as it is for creating join and then create the table with store command And what is the common field for join in this two tables i think it will be RepID if so then use same name in the tables.
you have RepID in the first table and RepsID in the second, if you want to join on the ID the fields will need to be the same name.
Based on that the only field you are currently joining on is DATE, which if it was working correctly would be giving you have big duplication in your temp table, so check the formats of DATE in the two tables.
Also, the only extra element you are doing in your final table looks to be loading a field subset (dropping Measure2),
you can just use 'drop field' and then just store the temp table, no real need to do the resident