title: sql except - one column not included
body: <p>I have two the same tables (one is a copy of another but records where inserted at different time). Let's say they look like that (but with like 40 columns instead of 3 like in my example):</p>
  
  <p>Table 1</p>
  
  <pre><code>a   b    time
  --------------
  1   5    13:00
  2   6    13:01
  3   7    13:02
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>a   b    time
  ---------------
  1   5    15:00
  2   6    15:01
  3   7    15:02
  </code></pre>
  
  <p>I would like to compare them using a simple EXCEPT like</p>
  
  <pre><code>SELECT * FROM Table 1
  EXCEPT 
  SELECT * FROM Table 2
  </code></pre>
  
  <p>I was trying with WHERE clause but it didn't work. How to do EXCEPT statement without a column time? because for me it's totally fine when in the time column I have different values. I am comparing them now using "not exists" but I would prefer some easier way to do it.</p>