UPDATE TeacherSite TS set OwnerSiteId= (SELECT TS2.HybridUserId, ST.WebSiteId FROM SchoolSite_Teachers ST INNER JOIN HybridUser U ON ST.HybridUserId = U.Id WHERE TS.HybridUserId = TS2.HybridUserId )