title: select max and min from multiple tables
body: <p>I am using SQL Server 2012. I have two tables that contain dates. I want to query the max and min dates from both tables. I know the line below will give me the max and min dates for one table.</p>
  
  <pre><code> select max(dtTime), min(dtTime) from tableOne
  </code></pre>
  
  <p>What I want to do is get the min of the two max dates from table one and two &amp; the max of the two min dates from the table. Please see the example below.</p>
  
  <pre><code>           TableOne       TableTwo
   Max Date  6-June-2000    23-June-2002
   Min Date  10-Jan-1980    15-Feb-1982
  </code></pre>
  
  <p>Result I would like returned,</p>
  
  <pre><code>Max Date = 6-June-2000
  Min Date = 15-Feb-1982
  </code></pre>