2 Replies Latest reply on Apr 4, 2007 4:58 PM by Grizzly9279

    How to use ONE query to find out tree structure?

    EZStudio04
      ID------------upperID----------Name------------------------isFolder
      1------------ 0---------- Folder 1------------------------------------1
      2------------ 1------------ Folder 1- Sub Folder--------------------1
      3------------ 2------------ Folder1-Item1-A--------------------------0
      4------------ 1------------ Folder 1- Sub Item-----------------------0


      Hi all, if I have a table like above to demonstrate the folders and item relationship. This structure allows the user to create unlimited folders and items.

      Now I would like to use one query to find out the tree structure of this table, how could I do the query.

      Any help on this will be highly appreciated!

      Thanks,


      ez