Recursive Joins or Parent/Child Trees
By Bill Graziano
on 15 September 2000
| 0 Comments
| 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.
