jamin 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 Men
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 displ
