SQL Updating two records
<p>I am trying to update two employee's data. Let say one employee's id is <code>1234</code> and the other employee's id is <code>5678</code>. Each employee has different services. </p>

<p>This is my table for reference</p>

<pre><code>serv_id          emp_id      serv_name    status 
1                 1234        computer1     A
5                 1234        computer2     A
10                1234        computer3     A
37                1234        computer4     A
5                 5678        computer2     A
11                5678        projector1    A
12                5678        projector2    A
30                5678        projector3    A
37                5678        computer4     A   
35                5678        projector4    A
</code></pre>

<p>In the table above, we have 2 employees with 10 records and each employee has 5 services. What I want to do right now is to merge these two employee's services into one employee (1234) because employee 5678 is fired. However, serv_id with '5' or '37' does not need to be updated in employee 1234. </p>

<p>Here is my expected result. Let say A is active and I is inactive. Any suggestion on how to do it? </p>

<pre><code>serv_id (pk)                 emp_id (fk)     serv_name    status 
1                            1234            computer1      A
5 (no update)                1234            computer2     A
10                           1234            computer3     A
11                           1234            projector1    A
12                           1234            projector2    A
30                           1234            projector3    A
35                           1234            projector4    A
37 (no update)               1234            computer4     A
11                           5678            projector1    I
37                           5678            computer4     I
5                            5678            computer2     I
11                           5678            projector1    I
12                           5678            projector2    I
30                           5678            projector3    I
37                           5678            computer4     I
35                           5678            projector4    I
</code></pre>