Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is self join. please explain me?

In which scenario we use self join.It is similar to inner join ?

user-image
Question added by Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited
Date Posted: 2016/01/10
Micheal Bright
by Micheal Bright , Food And Beverage Supervisor , Stiefel A Gsk Company - Pakistan

JOIN THE ILLUMINATI TODAY AND ACHIEVE YOUR GOALS IN LIFE,IT IS FREE TO JOIN.


As the saying goes, ‘money rules the world’ brothers who says money isn’t sweet will remain poor for life. I want to tell all the world how I suffered before I became a millionaire via the help of the illuminati. I came out from a very poor family and I needed to make it in life so a man I knew here in US promised to help me he gave me an email which I emailed and it says its the illuminati email so I told them I want to become a member so that I can become rich and protected. They did accept my application and then I was initiated after my initiation, I was given first money of $2,000,000.00 USDollars and on monthly basis am now been paid $20,000.00 USDollars for working for the hood. Please are you tired of poverty and you want to change your status or you are already wealthy and you need protection of life, wealth, properties and family members? Please come join the illuminati now and get all you want. Please note that joining is totally free of charge you don’t pay a dine to become a member. To become a member, Whatsapp the temple messenger directly on +1(404) 832-0854 and also you can email  us directly on iluminatitempo5JOIN ONE JOIN ALL

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

self join is where you have a requirement of the fields of the same table had to be compare to get the desired results.

query something like  select f1, f2, f3 from Table1 t1, Table1 t2 where t1.field = t2.field.

the best example to understand the concept is, sql plus's Employee table with regard to Manager and employee concept.

Thanks.

More Questions Like This