how to use the SQL Server self join to join a table to itself.
Shathana. S.R. Answered question May 29, 2023
SELF JOIN syntax
- To perform a SELF JOIN in SQL, the LEFT or INNER JOIN is usually used.
- SELECT column_names FROM Table1 t1 [INNER | LEFT] JOIN Table1 t2 ON join_predicate; Note: t1 and t2 are different table aliases for the same table.
- You can also create the SELF JOIN with the help of the WHERE clause.
Shathana. S.R. Answered question May 29, 2023