SELF JOIN in Teradata

SELF JOIN is a join where the join condition occurs on a same table.
This scenario occurs when a particular column values resembles/repeats in another column of a same table.

Syntax:
SELECT columns
FROM table a, table b         -- single table with two alias
WHERE a.column1 = b.column2; -- column1 resembles column2


Example:
To list all the employee names along with manager's name.
SELECT Emp.Employee_id, Emp.Employee_name, Emp.Manager_id,Manager.Employee_name
FROM tbl_employee Emp JOIN tbl_employee Manager
ON Emp.Manager_id = Manager.Employee_id;