title: Select query to pull same record twice
body: <p>I want to use a select query to pull the same record two times but with a different value the 2nd time for one of the fields.</p>
  
  <p>So I have a select query that currently pulls data and displays the following for example:</p>
  
  <pre><code>ProductCode   Description   Price   Currency
  123           Product1      200     CAD
  </code></pre>
  
  <p>Now I want to use the select query to pull the same record a second time but instead of having CAD I want to use USD, so it should display:</p>
  
  <pre><code>ProductCode   Description   Price   Currency
  123           Product1      200     CAD
  123           Product1      200     USD
  </code></pre>
  
  <p>The "CAD" is hard-coded for now in the select query, I hope this makes sense, eg. the select query right now is:</p>
  
  <pre><code>select productcode,description,price, 'CAD' as Currency from product_table
  </code></pre>