<div>
If this truly is SQL Server, the UPDATE with a JOIN happens like this:<br />
<br />

<pre><code id="code-20-42343946-1">UPDATE A
SET ...
FROM Table1 A
JOIN Table2 B ON ...</code></pre>
<br />
For your specific case, if you do not need to do the intermediate step, you actually can do the UPDATE using the original WHERE NOT EXISTS.<br />
<br />

<pre><code id="code-20-42343946-2">UPDATE [dbo].[Organization]
SET SalesUserID  = 0
WHERE NOT EXISTS (
  SELECT 1 FROM [dbo].[Users]
  WHERE UserID = SalesUserID
) AND SalesUserID &lt;&gt; 0</code></pre>
</div>


If this truly is SQL Server, the UPDATE with a JOIN happens like this:



UPDATE A
SET ...
FROM Table1 A
JOIN Table2 B ON ...


For your specific case, if you do not need to do the intermediate step, you actually can do the UPDATE using the original WHERE NOT EXISTS.



UPDATE [dbo].[Organization]
SET SalesUserID  = 0
WHERE NOT EXISTS (
  SELECT 1 FROM [dbo].[Users]
  WHERE UserID = SalesUserID
) AND SalesUserID <> 0

<div>
<div class="content wysiwyg-content">
Here's my try..<br />
<br />

<pre><code id="code-10-29064676-1">SELECT SalesUserID INTO Temp001 FROM [dbo].[Organization]
WHERE NOT EXISTS 
  (SELECT * FROM [dbo].[Users] WHERE UserID = SalesUserID)

Update [Organization]
    Inner Join Temp_Organization
        On Temp_Organization.SalesUserID = [Organization].SalesUserID
Set SalesUserID = 0</code></pre>
</div>
</div>


I need to find orphan records and update values to 0

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.