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 - 2006-02-13 : 08:24:52
|
| chakri writes "hi, there r 3 tablesXD ----(PK) (FK) (FK)uid rolid posid name 1 2 1 a 2 3 2 b3 3 3 c 4 4 4 d5 4 5 e6 4 6 f7 4 7 g8 4 8 h9 4 9 i YD---Posid(PK) parposid(FK) rolid(FK) 1 null 1 2 1 2 3 1 2 4 2 3 5 2 3 6 3 3 7 3 3 8 3 3 9 3 3ZD---Rolid(PK) parrolid(fk)Qus1: i/p:uid o/p:all child nodes under that hand Qus 2:i/p:uid o/p: all its parent nodes Qus3: i/p uid o/p: only its parent nodesplz some one get me out of this..chakri " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-02-13 : 08:25:12
|
| Sorry, we don't answer homework or exam questions on SQL Team. |
 |
|
|
|
|
|
parent and child nodes