Re-iterating search in SQL

[russellobrien]

Is the following possible in SQL?

I want to develop a hierarchy table with a list of objects that has the simple form below:

ID NAME PARENT CHILD

Where parent and child refer to parent(s) or child(ren) nodes. Can I develop a query that will say for instance find all child notes by iterating down repetitively til no children are found or do I need to programmatically do such a thing from my application itself
Many thanks,

Russell O'Brien

 

[mpastore]

I would just go programmatic on this....higher end DBMS' like Orace actually have this functionality built into their SQL dialect, MS Access does not.

Mike Pastore

Hats off to (Roy) Harper

 

[russellobrien]

Thanks there.
I may be porting to SQL Server. I know we are in Access land here but can you suggest how the clever DBMS's go about implementing this or where there is a suitable site for info.

Thanks again,

Russell

 

[MichaelRed]

include Parent/child Id.s in the record. Similar questions have been asked (and SOME information has been posted in response) in these fora. At least one response refers to "VISIO" as the program includes both a structure of htis nature and a query which generates the parent child listing. Annother reference should be found using "Linked List", as this it the basic (non-rdbms) term for the underlying process.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[KenReay]

hi

see

http://www.mvps.org/access/modules/mdl0027.htm

it may help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK