<div>
<div class="content wysiwyg-content">
Hi<br />
I have a table with 3 fields say ItemID, ParentID and ItemName<br />
<br />
It has parent child relationship. So for some Items a different ItemID will be in ParentID.<br />
and there is no limit to how long a parent child chain can go...i mean a item can have a child which had another child and that has another child like that....<br />
<br />
What i need to find out through query is...if i pass a parentID i need to get all the child and their child and their child ITEMIDs...<br />
<br />
How can we do it through query....<br />
<br />
thanks<br />
<br />
Mahesh
</div>
</div>


Hi
I have a table with 3 fields say ItemID, ParentID and ItemName

It has parent child relationship. So for some Items a different ItemID will be in ParentID.
and there is no limit to how long a parent child chain can go...i mean a item can have a child which had another child and that has another child like that....

What i need to find out through query is...if i pass a parentID i need to get all the child and their child and their child ITEMIDs...

How can we do it through query....

thanks

Mahesh

How to get child's child record through query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.