Ok I was assuming the data was already in two tables that could be indexed. My bad!!!
Oops, I think I misunderstood something. The data are in two separate tables that do have indexes on them. The wage data needs to be grouped.... hold on, it just occurred to me the data can be grouped by employee after the tables have been joined. (don't laugh, it seriously just occurred to me). I'll see where this leads.