title: Is it possible to write single query on two table which are not connected to each other?
body: <p>I have two tables, I am wondering whether is it possible to write a single query on  these two table  but they are not connected to each other? </p>
  
  <p>some sample code snippet whould be great helpful for my understanding. </p>
  
  <p>Table: <code>Payment</code> </p>
  
  <pre><code>Payment_id  Payment_status  amount
  1  1001          201            400
  2  1002          403            450
  3  1003          204            460
  </code></pre>
  
  <p>after running query : <code>SELECT Payment_status FROM Payment  GROUP BY Payment_staus</code> </p>
  
  <p>it gives me result like : </p>
  
  <pre><code>Payment_staus
  1 201
  2 403
  3 204
  </code></pre>
  
  <p>I have one more table named <code>status_code</code> as</p>
  
  <pre><code>  code    description
  1 201     In progress
  2 403     Complete
  3 204      On Hold
  </code></pre>
  
  <p>In above query I want Payment_staus and their respective description , the result should look like this</p>
  
  <pre><code>   Payment_status  description 
  1    201            In progress
  2    403            Complete
  3    204            On Hold
  </code></pre>