UPDATE TeacherSite set OwnerSiteId= (SELECT ST.WebSiteId FROM SchoolSite_Teachers ST WHERE ST.HybridUserId = TeacherSite.HybridUserId )