Hi.
Maybe I am missing something, but won't
SELECT M1.*,M2.*
FROM Menu AS M1
JOIN Menu AS M2 ON M1.ID = M2.ParentID
WHEREID=0
ORDER BY M1.Index, M2.Index
work?
Bye,
Benjamin.
On Tue, Nov 20, 2001 at 06:04:11PM -0800, [EMAIL PROTECTED] wrote:
I am trying to
Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 2:43 PM
To: Michael Collins
Cc: [EMAIL PROTECTED]
Subject: Re: Recursive select to produce hierarchical listing
Hi.
Maybe I am missing something, but won't
SELECT M1.*,M2.*
FROM Menu AS M1
JOIN Menu AS M2
I am trying to display a hierarchically related list of folders via a
recursive SQL statement (each row in a table represents a folder).
What is needed is a select that will sort the folders and associate
the parent folder with their child, sub-folders. The kicker is that
the items in the
I am trying to display a hierarchically related list of folders via a
recursive SQL statement (each row in a table represents a folder).
What is needed is a select that will sort the folders and associate
the parent folder with their child, sub-folders. The kicker is that
the items in the