title: How to Union Uncommon Columns in SQL
body: <p>What SELECT Statement should I write to get desired table from Tabel1 &amp; 2</p>
  
  <p><strong>Table 1 - Charge Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/0f5pZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0f5pZ.png" alt="Charge Table"></a></p>
  
  <p><strong>Table 2 - Order Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/XSref.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XSref.png" alt="Order Table"></a></p>
  
  <p><strong>Desired Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/5UayI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5UayI.png" alt="enter image description here"></a></p>