title: SQL Select distinct values from multiple tables
body: <p>So here's my setup I have 2 tables Old and New with the following (simplified) schemas</p>
  
  <pre><code>Old
  [ManName]
  [ManNumber]
  
  New
  [Manager_Name]
  [Manager_Number]
  </code></pre>
  
  <p>I'm looking to craft a SQL query that returns the following but in 4 columns in 1 query as opposed to 2 queries with 2 columns each </p>
  
  <pre><code>select distinct manname, mannumber from OLD 
  select distinct Manager_Name, Manager_Number from NEW
  </code></pre>
  
  <p>So my ideal Result Set would have 4 columns: </p>
  
  <pre><code>ManName ManNumber Manager_Name Manager Number 
  </code></pre>
  
  <p>Thanks! </p>