Question

374 viewsMay 29, 2023Office#SQLSERVER

1

Sandhya 2.52K May 26, 2023 0 Comments

how to use the SQL Server self join to join a table to itself.

score 0 · Answer 1 · 2023-05-29T06:12:55+00:00

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.

Questions