It looks like you need a full outer join on Date and Name. The full outer join ensures that in your result you will also get Dates and Names that are only present in Table1 or Table2.

SELECT *
FROM Table1
FULL OUTER JOIN Table2
ON Table1.Date = Table2.Date AND Table1.Name = Table2.Name