Home / SQL Server ALL keyword / SQL Server AS keyword / sql server inline if else / Sql server inner join / SQL Server SELF JOIN / What is SELF JOIN and when would you use it?

What is SELF JOIN and when would you use it?

Anil Singh 2:46 AM SQL Server ALL keyword , SQL Server AS keyword , sql server inline if else , Sql server inner join , SQL Server SELF JOIN Edit

A SELF JOIN is join which is used to join a table to itself.

There is no SELF JOIN keyword and it is used to compare values in a column with other values in the same column in the same table.

For Example,

SELECT * FROM TableA t1, TableA t2

WHERE t1.Id = t2.Id

In the above query, WHERE clause could be any given expression as per you!

I hope you are enjoying with this post! Please share with you friends!! Thank you!!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2