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.
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!!!