Make a query that show result in another column

Viewed 1215

i have a table like this :

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

i use this query to show result for referred name:

SELECT member_id,f_name,l_name,active_status,refered_by From Act_Reg where refered_by='nick'

query works good and return:

id - name
1  - mark
2  - david
3  - mat

now, i want to show results in a grid as row and coloumn :like this

id - referred_id - referred_name - refers(name of refers)
1  -  100        - nick          - mark , david , mat
2  -  101        - robert        - patrik , mick

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

4 Answers
Related