title: How to get multiple select query result in one line
body: <p>I want oracle SQL query, that should join two tables and get all the group rows from second table in one row.</p>
  
  <p>Example</p>
  
  <pre><code>field1    field2    field3
  1          Test1    Ttest1
  1          Test2    Ttest2
  1          Test3    Ttest2
  2          Test4    Ttest2 
  2          Test5    T2est2
  </code></pre>
  
  <p>Should be </p>
  
  <pre><code>Field 1   field2                   field3
  1         Test1,Test2,Test3        Ttest1,Ttest2
  2         Test4,Test5              Ttest2
  </code></pre>