Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
In which scenario we use self join.It is similar to inner join ?
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
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.
