Recursive Joins or Parent/Child Trees

By Bill Graziano on 15 September 2000 | Tags: JOINs

---

Patrick was the most recent person to ask about using SQL Server to return the rows based on a parent child relationship (like a message board). Our own sqlguru wrote two articles on this not too long ago.

These articles are were originally posted on 4GuysFromRolla.com. The first article (Performing Recursive Joins) covers the basics. Performing Complete Recursive Joins is the follow up article with more depth.

If you are planning a message board and wanting to maximize your use of SQL Server these articles will tell you what you can and can't do.

Related Articles Additional Criteria in the JOIN Clause (16 September 2002)

Other Recent Forum Posts Query performance Call Center data (20h) Looking for on Premises tool to read data from SQL logs and populate data warehouse (1d) Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (1d) Working with multiple WHERE statements (1d) Create a new field value that shows a difference in value from 2 fields (3d) Hierarchy wise Sales Targets (3d) Get the MaxDate in results (5d) Switch Statement within a SSRS SQL Expression (6d)