parent child - get all children for a specific row

Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
SayaIf you have SQL Server 2005, check out "Common Table Expressions" in the
BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Saya" <vaqas@.hotmail.com> wrote in message
news:1149257162.442872.321450@.i39g2000cwa.googlegroups.com...
Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
Saya