-
query help
I have a table, that has a parent child related data. for example
table name: test
parent child
------------- -----------
1
2 1
3 2
4 3
I want the output with parent, child and grandchild. for example
parent child grandchild
---------- ---------- --------------
1
2 1
3 2 1
4 3 2
can anybody help me
thanks
Nwcomer
Student
-
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|