Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-20 : 08:31:03
|
kris writes "hello,
i have a main table which has all the details like id,name,comments ,etc...and i ahve another table which has the parent -child relationships of the above table..
like
main table
id name comment..
1 xxx ccc
2 yyy ---
3 zzz ----
4 sss ---
5 ddd ---
another table..
ref table
parentid child_id(refering to above table)
1 2
1 3
2 4
2 5 ...and so on
i want a single query which return me the parent and all its childs ...
please help me out ASAP...
thank u...
kris" |
|
|
|
|
|
building hierarchy from dbase