title: Difference between 2 selects in SQL
body: <p>I have one data table: </p>
  
  <pre><code>--------------------
  ID |  user | Value
  --------------------
  1  |  1    | 1
  --------------------
  2  |  1    | 2
  --------------------
  3  |  2    | 3
  --------------------
  4  |  2    | 2
  --------------------
  5  |  3    | 4
  --------------------
  6  |  3    | 2
  --------------------
  </code></pre>
  
  <p>I would like to SELECT all rows where value is different comparing to user 1 so the result would be rows with IDs 3 (value is 3) and 5 (value is 2)</p>
  
  <p>I would do something like this (will call it A)</p>
  
  <pre><code>SELECT * FROM table WHERE user = 1
  </code></pre>
  
  <p>and get all the rows from user 1. Than I would select (will call it B)</p>
  
  <pre><code>SELECT * FROM table WHERE user != 1
  </code></pre>
  
  <p>and get all other rows. And than I would compare them <code>WHERE A.value != B.value</code>.  </p>
  
  <p>I'm stuck on how to merge everything together... </p>
  
  <p>Please help!</p>