title: How to use where not in
body: <p>I have this table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Customer</th>
  <th style="text-align: center;">Product</th>
  <th style="text-align: right;">Count</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">A</td>
  <td style="text-align: center;">123</td>
  <td style="text-align: right;">1</td>
  </tr>
  <tr>
  <td style="text-align: left;">A</td>
  <td style="text-align: center;">234</td>
  <td style="text-align: right;">0</td>
  </tr>
  <tr>
  <td style="text-align: left;">A</td>
  <td style="text-align: center;">345</td>
  <td style="text-align: right;">0</td>
  </tr>
  <tr>
  <td style="text-align: left;">B</td>
  <td style="text-align: center;">456</td>
  <td style="text-align: right;">1</td>
  </tr>
  <tr>
  <td style="text-align: left;">C</td>
  <td style="text-align: center;">567</td>
  <td style="text-align: right;">1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So I tried to write a query to return value as customers B and C</p>
  <pre><code>select customer from table 
  where customer not in (select customer from table where count = 0)
  </code></pre>
  <p>However, I didn't get a return for this query. I want to get results from the query is customer B and C not customer A</p>
  <p>Is there a way to fix it? I use an Oracle database</p>