--- In ib-support@y..., "jwcanada" <jwcanada@y...> wrote:

> What is the best way to store and retrieve hierarchical

information?

> I am think about to create a table like
>
> ID, PARARENT_ID, SUBJECT

I think this is not the best way to do it...

You might want to have a look at this article:
http://www.dbmsmag.com/9603d06.html

Berenger