SQL Self Joins | Self Join in SQL Server

Video talks about
SQL Self Joins
Self Join in SQL Server
why do we need self join in sql server
SQL Right Joins
Right outer joins in sql
SQL Left Join
Left outer join in SQL
joins in sql
sql server joins
left join in sql
full outer join in sql
inner join in sql

Part of
sql joins tutorial
Step by step SQL Training videos
SQL Tutorial

more videos at

[SaurabhKumar-nwgu]

Sir, in the ON clause if we do e.idemp = m.mgrid instead of m.idemp = e.mgrid then why the result changes, as it is a self join. Please explain