N-Level Quiries (Hierarchical Retrieval)
Posted on 2001-06-23
I wanted to know, how can I do a tree query on a table, which allows me to retrieve the entire tree structure or sub-tree structure using one query. For example if I wanted to list all data from the root to all the nodes (having id and parentid as the identifier in the table). As I understand Oracle has the features of "Connect BY PRIOR and START WITH" to allow me to do this, but what can I use in Access.