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 My informix Sql query retruns Null always (12h) Vehicle availability query (1d) SSDT - Unable to reference 'master' or 'msdb' with new sdk style project (1d) Ola Hallengren backup jobs (1d) Compare alpha results to INT after get values from a string (5d) Query performance Call Center data (6d) Looking for on Premises tool to read data from SQL logs and populate data warehouse (7d) Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (7d)