SQL Server 2008 Update Query with Join and Where clause in joined table - Stack Overflow

SQL Server 2008 Update Query with Join and Where clause in joined table - Stack Overflow

瀏覽:1216
日期:2025-06-10
Yep you've overlooked something. The set statement cannot reference the alias on the left side of the set. Try: UPDATE ust SET isUnsubscribedFromSystemEmails = 1 --select * FROM UserSetting AS ust INNER JOIN [User] ON ust.userID ......看更多