title: Multiple select from a result table into a single row in oracle
body: <p>I was struggling to find a way to replace multiple JOIN with inner select in SQL command but nothing found up to now. I have a query which joins 11 tables and due to multiple roles I have to have 21 joins in my query. so I decided to find more information in my tables and found out I have a table which has proper information to relate some tables.  [my result table ][1]<br>
   as you can see I have a field named "Mainuuid" which is relevant with different "Slave" values. Each slave value is primary key in it's relative table. 
  So what I need is a single row which is computed from multiple select based on the result image for example: I named the result table as "test"</p>
  
  <ul>
  <li>SELECT a,b FROM person WHERE Id=test.slave, </li>
  <li>SELECT x,y FROM Unit WHERE Id=test.slave, </li>
  <li><p>SELECT o,p FROM naturalperson WHERE   Id=test.slave</p>
  
  <p>And I want to put all result in a single row! any suggestion will be appreciated.</p>
  
  <p>[1]: <a href="http://i.stack.imgur.com/7pK2D.jpg" rel="nofollow">http://i.stack.imgur.com/7pK2D.jpg</a></p></li>
  </ul>