i have table as below:
ID Name UserCreatedID
1 John
2 Rose 1
3 Nancy 1
4 April 3
so what i want to display at below:
Name UserCreatedbyName
John
Rose John
Nancy John
April Nancy
all at the same table.
please help.