All pastes #902566 Raw Edit

Untitled

public text v1 · immutable
·published 2008-02-13 16:49 UTC
rendered paste body
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
	)