Solved

How to get child's child record through query

Posted on 2007-03-19
3
312 Views
Last Modified: 2010-03-20
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
0
Comment
Question by:ziorrinfotech
3 Comments
 
LVL 4

Accepted Solution

by:
indu_mk earned 125 total points
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now