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 |
|
ts_abbott@hotmail.com
Starting Member
36 Posts |
 Posted - 2004-11-08 : 10:08:26
|
| hi,i'm trying to select all items from a table starting with parentid x but i'm not sure how to go about it.This is my table structure:[i_Page]PageId | ParentPageId | Name1 | 0 | Home2 | 1 | Home Sub Item3 | 1 | 2nd Home Sub Item4 | 2 | A subitem which appears under PageId 2Is it possible to select * from i_Page WHERE PageParentId=1 and all child items' underneath?cheerstim |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
ts_abbott@hotmail.com
Starting Member
36 Posts |
Posted - 2004-11-08 : 14:09:00
|
| thanks, i'll have a look at your website. |
 |
|
|
|
|
|
recursive select