title: sql create view in one to many relation
body: <p>I want to create a view in a one-to-many relation.
  Here are my relations:</p>
  
  <pre><code>(a -* b)
  (a -* c)
  </code></pre>
  
  <p>I want to create a view to have this data:</p>
  
  <ul>
  <li>a1 - (all b's related to a1 + all c's related to a1)</li>
  </ul>
  
  <p>I don't want something like (a1,b1,c1 - a1,b1,c2 ,...).
  I want data to be:</p>
  
  <p>(ID,DESCRIPTION1,DESCRIPTION2,DESCRIPTION3)</p>
  
  <p>in one record.</p>
  
  <p>For example, if in table a I have data: (1,2,3)</p>
  
  <p>and in table b I have (10,11,12 with fk to 1 in a and 20,21,22 with fk to 2 in a)</p>
  
  <p>and in table c I have (100,101,102 with fk to 1 in a)</p>
  
  <p>I want result like this in one row:</p>
  
  <p>1,10,11,12,100,101,102 for 1</p>
  
  <p>and something like this for 2 , 3 ,...</p>
  
  <p>i think i need "single row subquery example" but i can't find any example , can you help me plz ?</p>
  
  <p>How can I create this view?</p>