Self Join in SQL

try this coding,

SELECT column_name(s)
FROM table_name1
FULL JOIN table_name2
ON table_name1.column_name=table_name2.column_name
and also go http://www.w3schools.com/sql/sql_join.asp many query will available.
Please tick correct answer

Satyapriya Nayak13y ago

Self join is very useful in the case where there is a need for join in a single table itself.
When all of the data you want to retrieve is contained within a single table, but data needed to extract is related to each other in the table itself.

http://hightechpost.blogspot.in/2011/07/self-join-in-sql-server.html

http://learnsqlserver.in/3/Self-Join.aspx

http://www.sql-statements.com/sql-self-join.html

http://www.sqltutorial.org/sqlselfjoin.aspx

Sivaraman Dhamodaran13y ago

To Vithal: Refer this LINK

Vithal Wadje13y ago

good answer shanker sir but if you expalined why need to use self join then then it become even better

Shankar M13y ago

Hi Manish,

Self - Join is joining a table to itself,considering each as individual tables usually with an alias name to differentiate each other.

Generally, we will write Self-join like this,

SELECT a.col_name, b.col_name.. FROM table1 a, table1 b WHERE a.col_compared = b.col_compared;

Here the alias name for table1 is a and b respectively..

Thanks,
Shankar