title: Create view by selecting different columns from multiple tables in SQL server
body: <p>Im trying to create a view where specific Columns from 2 tables to be combined.</p>
  
  <h2>My Tables</h2>
  
  <p><code>Table1(Column1,Column2,Column3)</code></p>
  
  <p><code>Table2(Column4,Column5,Column6)</code></p>
  
  <h2>Expected output</h2>
  
  <p><code>View1(Column2,Column3,Column6)</code></p>
  
  <p>What query can i use to achieve that output?</p>