Something like this?
MAX(Table2.Date) AS MostRecentActivity
LEFT OUTER JOIN
ON Table1.Name = Table2.Name
If that doesn't help, check these links for how to ask your question in a way that makes it eaiser for us to help you: