Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I need some information!
- Thread starter Ravi29
- Start date
Hi there ...
what is it you are trying to do exactly??
A hierarchical query is a SQL query that shows parent child relationships between records that are often in the
same table. Almost all data has a natural hierarchical structure which can be used to present data in a more
meaningful way.
Which means .. there is no 'defined' syntax as such, its about presenting meaningful data by structuring your query properly ... as far as I can tell
Hope this helps
Transcend
what is it you are trying to do exactly??
A hierarchical query is a SQL query that shows parent child relationships between records that are often in the
same table. Almost all data has a natural hierarchical structure which can be used to present data in a more
meaningful way.
Which means .. there is no 'defined' syntax as such, its about presenting meaningful data by structuring your query properly ... as far as I can tell
Hope this helps
Transcend
- Thread starter
- #3
hi Transcend!
see if i have like thais structure in a table
ID Name Parentid
1 raju 0
2 Rama 1
3 Mani 2
4 renuka 2
5 rani 1
6 venkat 0
7 mani 6
if i make a query,what are all the person involved in raju famly in a single query?
with regards
Ravichandran.v
see if i have like thais structure in a table
ID Name Parentid
1 raju 0
2 Rama 1
3 Mani 2
4 renuka 2
5 rani 1
6 venkat 0
7 mani 6
if i make a query,what are all the person involved in raju famly in a single query?
with regards
Ravichandran.v
- Status
Similar threads
- Locked
- Question
- Locked
- Question