title: Merging of 2 Tables but different value of fields
body: <p>I am using MS SQL to create a report to merge 2 tables. The problem is that I need 2 different headers and 1 column needs to have values from 2 different fields from the 2 tables. </p>
  
  <p>Sample</p>
  
  <pre><code>Material             |         Plant
  -------------------------------------------------
  Component            |        Quantity
  
  
  XXX - Material       |        ABC--Plant
  --------------------------------------------------
  YYYY-Component       |       3000- Quantity
  </code></pre>
  
  <p>Is this even possible?</p>