-----Original Message-----
From: Mike Connolly [mailto:[EMAIL PROTECTED]
Sent: maandag 12 januari 2004 12:38
To: CF-Talk
Subject: Nested Tree SQL Sorting
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]
