Santosh Sasupalli

Santosh Sasupalli

  • 1.4k
  • 181
  • 22.9k

sql join query a table itself

Sep 2 2016 6:46 AM
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
 

Answers (3)