title: Concatenate result of two select statements
body: <p>My query is something like: </p>
  
  <pre><code>concatenate( 
   (select col1 from table1) , ( select col1.substr(1,&lt;tillENd&gt;) ) 
  )
  </code></pre>
  
  <p>This works fine if both sub-selects return one row and one column. In my case, both will give multiple rows but one column.</p>
  
  <p>I want to concatenate them row-wise. How can I do this?</p>
  
  <hr>
  
  <p>Update:  complete queries are something like the following.</p>
  
  <p>Query 1:</p>
  
  <pre><code>select col3 
  from tabl2 
  where col2 in (select substr(A,1,instr(A,'_',-1)-1) 
                 from ( select substr(col1,1,instr(col1,'/')-1) as A 
                        from ( select col1 from tabl1 ) 
  
                 ) 
             ) 
  </code></pre>
  
  <p>seond select query: </p>
  
  <pre><code>select substr(col1,instr(col1,'/')) as A1 
  from ( select col1 
  from tabl1 ) 
  </code></pre>