title: How to get max value from 2 tables
body: <p>Using Sql Server</p>
  
  <p>I want to get max value from two table</p>
  
  <p>Table1</p>
  
  <pre><code>ID Total
  
  101 100
  102 600
  .....
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>ID Total
  
  101 300
  102 400
  ....
  </code></pre>
  
  <p>I want to get a max value from 2 table according to the id</p>
  
  <p>Expected Output</p>
  
  <pre><code>ID Total
  
  101 300 (max value in table2)
  102 600 (max value in table1)
  ....
  ...
  </code></pre>
  
  <p>How to make a Query</p>
  
  <p>Need Query Help</p>