: Joe Mellon [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 4:38 AM
To: [EMAIL PROTECTED]
Subject: SELF JOIN implementing a logical tree on one table
Hi Mysqlers,
I have a table which implements a tree-like heirarchy:
In the example below a geographical heirarchy.
I would like to be ab
Hi Mysqlers,
I have a table which implements a tree-like heirarchy:
In the example below a geographical heirarchy.
I would like to be able to pick a node in the tree and
Get everything logically below that node in the heirarchy:
(A self join?)
#
# Table structure for `tree`
#
CREATE TABLE `
