title: How to make a multiple select query in Firebird
body: <p>In MySQL I can perform the query I pastebin <a href="http://pastebin.com/PFRB2X0b" rel="nofollow noreferrer">here</a>. This query results the following result set:</p>
  
  <p><img src="https://i.stack.imgur.com/6s758.png" alt="result set from the pastebin query"></p>
  
  <p>How can I do something like it against a Firebird database? <code></code></p>