sql join query a table itself

Question

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

Bikesh Srivastava · Answer

Can you share whatever you have tried ....

Lokesh Kumar · Answer

Please Try This ... Select t1.uidt1.unamet1.pwd t2.uid as createdbyt2.uname as createdbyname FROM firsttablename t1 secondtablename t2 WHERE t1.createdby =t2.uid and t1.uid=3

Midhun T P · Answer

Hi You can use self join in SQL for this - SELECT a.uida.unamea.pwdb.uid as createdbyb.uname as createdbyname FROM tablename a tablename b WHERE a.createdby = b.uid and a.uid=3;