title: union two queries but not horizontal as vertical
body: <p>I wanna union two queries as vertical, so not using union parameters normally.</p>
  
  <pre><code>select 
     Code, Name, Category, SubCategory, p.Brand, Model, Price, Currency,
     Unit, Template, F1, F2,P1, P2, DiscountPercent as PrivateDiscount from 
  Products as p 
     left join ProductTemplates as pt on pt.TemplateName=p.Template
     left join Discounts as d 
     on d.Brand = p.Brand and d.Status=1 and d.CustomerID='1198' and d.DiscountType=0 
  
  select DiscountPercent as PublicDiscount 
  from Products as p 
     left join ProductTemplates as pt on pt.TemplateName=p.Template
     left join Discounts as d 
     on d.Brand = p.Brand and d.Status=1 and d.DiscountType=1
  </code></pre>
  
  <p>out:query1</p>
  
  <pre><code>colum name  | Code  | Name  | Category  | Brand  | PrivateDiscount |
  1.row _____ | ssff3 | adcdd | affcdcddd | assfdd | %6              |
  2.row _____ | scf3  | adcdd | affcdcddd | assfdd | %6              |
  </code></pre>
  
  <p>out:query2</p>
  
  <pre><code>colum name | PublicDiscount |
  1.row _____| %2             |
  2.row _____| %3             |
  </code></pre>
  
  <hr>
  
  <p>I wanna this result:</p>
  
  <pre><code>colum name : | Code  | Name  | Category  | Brand  | PrivateDiscount | PublicDiscount |
  1.row _____  | ssff3 | adcdd | affcdcddd | assfdd | %6              | %2 |
  2.row _____  | scf3f | adcdd | affcdcddd | assfdd | %6              | %3 |
  </code></pre>
  
  <p>As a result, shoult be column "PublicDiscount", next to column "PrivateDiscount"
  how can to that?</p>