title: ms sql Adding 2 rows, based on data in another table
body: <p>Have a table (lets name it table1) with this:</p>
  
  <pre><code>Company, Account, OtherData
  </code></pre>
  
  <p>There are multiple accounts per company. There a multiple companies.</p>
  
  <p>Now there are 2 types of companies: A-Type and B-Type. 
  (type of the company can be derived from the name of the company - lets say they start with A or B)</p>
  
  <p>Every A-Type Company has a matching B-Type company. Its a  1-1 relation. There is another table (table2) which maps company A to B</p>
  
  <pre><code>A-Type Company, B-Type Company.
  </code></pre>
  
  <p>What I would like to achieve is a result set that looks like that</p>
  
  <pre><code>A-Type Company, B-Type Company, 
  Account (there are multiple accounts per company), 
  OtherDataA (that came from A-Type row), 
  OtherDataB (that came from B-Type row)
  </code></pre>