title: MySQL - Is it possible to get 'the difference' of two query results?
body: <p>I need to merge two query results as in union, but I want to only keep the difference between the two results. Is this possible?</p>
  
  <p>I am basically selecting ALL resources in Query 1, and NOT-ALLOWED resources in Query 2, I obviously need the ALLOWED resources in my last result.</p>
  
  <p>In pseodo-code:</p>
  
  <pre><code>Query1 - Query2
  </code></pre>
  
  <p>Queryresult 1: </p>
  
  <pre><code>+-------+
  |  id   |
  +-------+
  |   1   |
  +-------+
  |   2   |
  +-------+
  |   3   |
  +-------+
  |   4   |
  +-------+
  |   5   |
  +-------+
  |   6   |
  +-------+
  </code></pre>
  
  <p>Queryresult 2: </p>
  
  <pre><code>+-------+
  |  id   |
  +-------+
  |   2   |
  +-------+
  |   5   |
  +-------+
  </code></pre>
  
  <p>Needed: </p>
  
  <pre><code>+-------+
  |  id   |
  +-------+
  |   1   |
  +-------+
  |   3   |
  +-------+
  |   4   |
  +-------+
  |   6   |
  +-------+
  </code></pre>