JOIN clause is used to combine rows from two or more tables based on a related column between them.
self JOIN is a regular join, but the table is joined with itself – this is extremely useful for comparisons within a table.
Joining a table with itself means that each row of the table is combined with itself and with every other row of the table.
SELECT column_names FROM table1 T1, table1 T2 WHERE condition;
Aliases for the actual table names are used to distinguish column names from one another since both of the tables have the same name.
T2 are aliases for the same table.
The following table has been created:
1. User Info
|First Name||Last Name||City|
To match customers that are from the same city, we have used the following SQL query that self joins the table:
SELECT A.City, B.name AS FirstName1, A.name AS FirstName2 FROM user_info A, user_info B WHERE A.name <> B.name AND A.city = B.city ORDER BY A.city
View all Courses