Self join
Self join is a join in which a table is joined with itself ,
specially when the table has a FOREIGN KEY which references its own PRIMARY
KEY. To join a table itself means that each row of the table is combined with
itself and with every other row of the table.The self join can be viewed as a
join of two copies of the same table. The table is not actually copied, but SQL
performs the command as though it were.
Please Check the example Below.
