title: Sum and compare columns from different tables and databases
body: <p>I have two tables I'd like to compare.  They are in separate databases and servers as well.  I've added a linked server and can query this from within Server 1.</p>
  
  <p>Table1 on Server1 provides breakdowns of submitted data.  For example <strong>ref#123</strong> may appear 3 times with values of 100, 150, and 200 (total <strong>450</strong>). I want to compare Table2 on Server2 that also has <strong>ref#123</strong> and the totals, and return the correct record if the total is different to <strong>450</strong>.</p>
  
  <p>Hope this makes sense! Thanks</p>