title: MySQL not in Where
body: <p>I have a table named as "Project" with project data as follows. </p>
  
  <pre><code>+--------+------------+------------+----------+--------+---------------+--------+
  | In Num | pro_no_old | pro_no_new | pro_name | amount | budget_status | status |
  +--------+------------+------------+----------+--------+---------------+--------+
  |      1 | pro1       |            | project1 | 200000 | original      |      1 |
  |      2 | pro2       |            | project2 | 150000 | original      |      1 |
  |      3 | pro3       |            | project3 | 300000 | original      |      1 |
  |      4 | pro2       | pro4       | project4 | 100000 | revised       |      0 |
  +--------+------------+------------+----------+--------+---------------+--------+
  </code></pre>
  
  <p>02) The pro_name, "Project4" has become from Project2 by revising. Then I need to get projects without revised projects like Project2. In the other words, no need to get previous project of a revised one. Desired Out put may be as follows.</p>
  
  <pre><code>+--------+------------+------------+----------+--------+---------------+--------+
  | In Num | pro_no_old | pro_no_new | pro_name | amount | budget_status | status |
  +--------+------------+------------+----------+--------+---------------+--------+
  |      1 | pro1       |            | project1 | 200000 | original      |      1 |
  |      3 | pro3       |            | project3 | 300000 | original      |      1 |
  |      4 | pro2       | pro4       | project4 | 100000 | revised       |      0 |
  +--------+------------+------------+----------+--------+---------------+--------+
  </code></pre>
  
  <p>03) I used the following query to get the desired output.</p>
  
  <pre><code>SELECT * FROM project WHERE('pro_no_old in (SELECT  pro_no_old FROM project where budget_status = "original"))
  </code></pre>
  
  <p>04) But didn't get the expected result. Can anyone help me ?    </p>
  
  <h1>Desired output after Editing</h1>
  
  <pre><code>+--------+------------+------------+----------+--------+---------------+--------+
  | In Num | pro_no_old | pro_no_new | pro_name | amount | budget_status | status |
  +--------+------------+------------+----------+--------+---------------+--------+
  |      1 | pro1       |            | project1 | 200000 | original      |      1 |
  |      3 | pro3       |            | project3 | 300000 | original      |      1 |
  |      5 | pro4       | pro5       | project5 |  50000 | revised       |      0 |
  +--------+------------+------------+----------+--------+---------------+--------+
  </code></pre>