UPDATE tblMenu
LEFT JOIN tblSoups ON tblMenu.Day = tblSoups.Day
SET tblMenu.SoupOfTheDay = tblSoups.Name;