title: How can I get a difference of two columns in two different tables in a SELECT query
body: <p>I have the two queries below I'd like to combine into one and get a difference result.</p>
  
  <p>Query 1</p>
  
  <pre><code>SELECT SUM(col1 + col2) As total FROM tableA
  </code></pre>
  
  <p>Query 2</p>
  
  <pre><code>SELECT SUM(total) FROM tableB WHERE color not like '%black' and model not like 'CF%'
  </code></pre>
  
  <p>I'd like to combine these in a SELECT query and get the result: Query 1 - Query 2 = result. The tables both have a "id" as a common key between them. I'm using MS SQL Server 2008</p>