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.