Self Join is designed to return rows with other rows within the same table. Table1 is joined with itself.
SELECT column_name1,column_name2,...
FROM table_name1 tab1,
INNER JOIN table_name1 tab2 ON condition;
We are joining employees to their managers. You must use ALIAS for the table to distinguish the difference.
