Use of SQL Self JOIN

SQL Self JOIN. In this lesson, I will show you how to use SQL Self JOIN on while querying data from the database using the SQL query.

 

SELF JOIN Syntax:

SELECT t1.column, t2.column
FROM table1 t1, table1 t2
WHERE condition;

Example:

SELECT A.name AS name1, B.name AS name2
FROM employees A, employees B
WHERE A.id <> B.id;