title: Make a query that show result in another column
body: <p>i have a table like this :</p>
  
  <pre><code>id - name - referred_id - referred_name
  1  - mark -   100  -      nick
  2  - david-   100  -      nick 
  3  - mat -    100  -      nick
  4  - patrik-  101  -      robert
  5  - mick -   101  -      robert
  </code></pre>
  
  <p>i use this query to show result for referred name:</p>
  
  <pre><code>SELECT member_id,f_name,l_name,active_status,refered_by From Act_Reg where refered_by='nick'
  </code></pre>
  
  <p>query works good and return:</p>
  
  <pre><code>id - name
  1  - mark
  2  - david
  3  - mat
  </code></pre>
  
  <p>now, i want to show results in a grid as row and coloumn :like this</p>
  
  <pre><code>id - referred_id - referred_name - refers(name of refers)
  1  -  100        - nick          - mark , david , mat
  2  -  101        - robert        - patrik , mick
  </code></pre>
  
  <p>My goal is that anyone who has introduced as report,for example:
  nick introduced mark,david,mat
  I use a access as database, thanks all </p>