title: UPDATE query involving multiple tables
body: <p>I have two tables..</p>
  
  <p>Persons:</p>
  
  <pre><code>  empid(primary key)
    firstname
    lastname
    email
  </code></pre>
  
  <p>Details:</p>
  
  <pre><code>  Did(primary key)
    salary
    designation
    empid
  </code></pre>
  
  <p>Now I need to UPDATE email of the employee whose name is 'abc' AND designation is Manager.(lets suppose there are more than one employees names abc and therefore designation needs to be checked)
  I am using sql server 2008</p>