title: Eliminate data from one table w.r.t other table
body: <p>I have 2 tables. say, Employee and User. EmployeeId, Status are common fields in both the tables. I need to check in Employee table and maintain data in User table.  </p>
  
  <p>For example:</p>
  
  <pre><code>Employee
  -------------
  EmployeeId    Status     EmpName
  1111          Active     Mary
  1112          Active     Joseph
  1113          Inactive   Elizabeth 
  
  User
  -------------
  EmployeeId    Status     UserName
  1111          Active     Mary
  1114          Active     Rachel
  </code></pre>
  
  <p>I would like to eliminate data in User table if it is already available in Employee table.</p>
  
  <p>Result would be</p>
  
  <pre><code>TmpUser
  -------------
  EmployeeId    Status     UserName
  1114          Active     Rachel
  </code></pre>
  
  <p>Please help to write query for the same.</p>
  
  <p>Thanks in advance</p>