title: How to use union all with manual value (not from another tabel)?
body: <p>I want to use union all with manual value, not from another table. And the values are:</p>
  
  <pre><code>|cSatuan1|cSatuan2|nkonversi|
  =============================
  |   LTR  |   PCS  |    1    |
  |   PCS  |   LTR  |    1    |
  </code></pre>
  
  <p>I've made the query with my own way, but it gets error. here is the query:</p>
  
  <pre><code>SELECT csatuan2, csatuan1, nkonversi
  FROM ms_metriks union all select 'LTR','PCS','1','PCS','LTR','1'
  </code></pre>
  
  <p>Can you tell me what's wrong with my query, and what is the right query?</p>