Essential Books

Recursive JOINs

suggest change

Recursive joins are often used to obtain parent-child data. In SQL, they are implemented with recursive common table expressions, for example: 

WITH RECURSIVE MyDescendants AS (
    SELECT Name
    FROM People
    WHERE Name = 'John Doe'

    UNION ALL

    SELECT People.Name
    FROM People
    JOIN MyDescendants ON People.Name = MyDescendants.Parent
)
SELECT * FROM MyDescendants;
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

JOIN:
* JOIN
* Self Join
* Differences between innerouter joins
* JOIN Terminology Inner Outer Semi Anti...
* Left Outer Join
* Implicit Join
* Basic explicit inner join
* Joining on a Subquery
* CROSS APPLY LATERAL JOIN
* FULL JOIN
* Recursive JOINs
* CROSS JOIN
Table Of Contents