title: mysql - do not display data if a certain condition is met
body: <p>Sorry I don't really know how to make a title for this because I can't explain it really. for example i have here a table</p>
  
  <pre><code>c_id   emp_id   clinic_id
  1      1         1
  2      1         2
  3      2         1
  4      3         3
  5      1         3
  </code></pre>
  
  <p>now i will do a query like this</p>
  
  <pre><code>select distinct * from table where clinic_id &lt;&gt; 1
  </code></pre>
  
  <p>And the result would be</p>
  
  <pre><code>c_id   emp_id   clinic_id
  2      1         2
  4      3         3
  5      1         3
  </code></pre>
  
  <p>at this point I need help, if from the <code>where clinic_id &lt;&gt; 1</code> a certain <code>emp_id</code> is within its row of condition(Sorry for my bad english). for example <code>emp_id 1</code>. All <code>emp_id 1</code> must not be display also.
  So the result would be just</p>
  
  <pre><code>c_id   emp_id   clinic_id
  4      3         3 // *The result I want*
  </code></pre>