Probably going to need some more information to help on this one, some example data would be helpful.
What happens when trying to join them i.e. the resulting table?
From the information i would guess that the Data in the Key in in table 1 and 2 is different so they are not joining. The must match exactly, case as well.
Also notice in you script you use date in the key and the field below is Date, the must both be Date as it is case sensitive.