Loading

sql join query a table itself

Santosh Sasupalli

i have a table like this

uid

uname

pwd

cretaedby(who creates this that person id i.e uid;if u only register then ur uid and createdby same)

now my question is

you have to see your details createdby shown uname(who create it nit his id)

how to write join query to show like this

uid uname pwd createdby(uid) createdbyname(uname)

thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.