[RESOLVED] query help

[phpsharma]

Hi All,

table1 structure

uid|name|sponsor

1| sharma|1
2|abcd1|1
3|abcd2|2
4|abcd3|2
5|abcd4|1
6|xyzas|1

how can i show username in the output? sql statement ?

1| sharma|sharma
2|abcd1|sharma
3|abcd2|abcd1
4|abcd3|abcd1
5|abcd4|sharma
6|xyzas|sharma

Thanks In advance
Ram

[jheitz]

select a.uid, a.name, b.name
from table1 a, table2 a
where a.sponsor = b.uid

[jheitz]

select a.uid, a.name, b.name
from table1 a, table1 b
where a.sponsor = b.uid

[phpsharma]

Thanks a lot jheitz,It works,

"You have 2 ears and 1 mouth, use them accordingly"

The above 2+1 is fine. Only issue is mind. Not Working some times..Just joking