title: How to Update Using Join (Linked Server)
body: <p>I want to match the data between 2 databases.
  I have 2 Databases. Aa and Bb, and I want to compare Aa to Bb. Database Bb is in linked server</p>
  
  <p>I have join code like this</p>
  
  <pre><code>SELECT
  B.Employee_Name, B.Employee_NIP, B.DomainName, A.NAMA, A.NIP,
  A.StatusEmployee, A.ActiveStatus
  FROM
  [SERVER-B].Bb.dbo.employee_hierar AS B RIGHT OUTER JOIN
  Bb AS B ON B.NIP = A.Employee_NIP
  </code></pre>
  
  <p>and I want update A.StatusEmployee from Y to N if there is NULL data on B.Employee_Name and B.Employee_NIP</p>
  
  <p>note:
  SQLServer</p>
  
  <p>Please Advice</p>