Nested Tree SQL Sorting

[Mike Connolly]

I have a simple table with the following kind of structure:


TYPES
+ TypeID
+ ParentID
+ Title


This table stores a nested tree of types.


I would like to know if it is possible from a single SQL query to return
my types in the following order:


TYPE 1
-- sub-type 1
-- sub-type 2
TYPE 2
-- sub-type 3
   -- sub-sub-type 1
   -- sub-sub-type 2
      -- sub-sub-sub-type 1
   -- sub-type 3
-- sub-type 4
   -- sub-sub-type 3
...etc....


Regards


Mike

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---