title: Return records of one value and not in other values
body: <p>Apologies for asking such simple question but here I am getting trouble while getting records from single table, my table contains records which have different values in <code>prod_code</code> for similar <code>product_number</code>. I want records of such <code>product_number</code> which have specific <code>prod_code</code>, and not others. For example from below table I need a records which have only <code>prod_code</code> with value <code>CIOFB1</code> and not <code>CIOFB2</code>, <code>CIOFB2</code>.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>product_number</th>
  <th>prod_code</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A1NU0001093</td>
  <td>CIOFB1</td>
  </tr>
  <tr>
  <td>A1NU0001093</td>
  <td>CIOFB2</td>
  </tr>
  <tr>
  <td>A1NU0001093</td>
  <td>CIOFB3</td>
  </tr>
  <tr>
  <td>A1NU0001094</td>
  <td>CIOFB1</td>
  </tr>
  <tr>
  <td>A1NU0001094</td>
  <td>CIOFB2</td>
  </tr>
  <tr>
  <td>A1NU0001094</td>
  <td>CIOFB3</td>
  </tr>
  <tr>
  <td>A1NU0001095</td>
  <td>CIOFB1</td>
  </tr>
  <tr>
  <td>A1NU0001096</td>
  <td>CIOFB1</td>
  </tr>
  <tr>
  <td>A1NU0001096</td>
  <td>CIOFB2</td>
  </tr>
  <tr>
  <td>A1NU0001096</td>
  <td>CIOFB3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried creating this query but not getting the records as expected:</p>
  <pre><code>SELECT * FROM product_number WHERE prod_code= 'CIOFB1'
  AND prod_code NOT IN ('CIOFB2', 'CIOFB3') ;
  </code></pre>
  <p>output:</p>
  <pre><code>A1NU0001095   CIOFB1
  </code></pre>
  <p>As other <code>product_number</code> do have all the <code>prod_code</code></p>