title: Update statement that will update the "Active" field of an employee if the corresponding department is inactive
body: <p>I want to update my employee's <code>Employee_Type</code>: if the <code>Department_Type</code> is <code>Inactive</code>, then the <code>Employee_Type</code> must be updated to also be <code>Inactive</code>.</p>
  
  <p>This is my code I don't know why isn't working. There is primary key in <code>tblEmployees</code> which is <code>EmployeeID</code>, and there is a foreign key in <code>tblDepartment</code> which also <code>EmployeeID</code>:</p>
  
  <pre><code>UPDATE tblEmployees
  SET Employee_Type = t2.Department_Type
  FROM dbo.tblEmployees AS t1
  RIGHT JOIN dbo.tblDepartment AS t2 ON t1.Employee_Type = t2.Department_Type
  WHERE t2.EmployeeID = '6';
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>(1 row(s) affected)
  </code></pre>
  
  <p>But nothing happens actually.</p>