Re: parent/child relationship in the same table.

MSherrill_at_compuserve.com wrote in message news:<3bf57b92.22398667_at_news.compuserve.com>...
> On 15 Nov 2001 20:11:34 -0800, jason_at_injektilo.org (Jason Diamond)
> wrote:
>
> >This sounded like a one-to-many
> >relationship to me so I added a parent column to the table.
>
> Aren't one-to-many relationships defined as invoving two tables?

Yes and no. There is the concept of a one to many self join. Obviously one instance of the table needs to be aliased so you could say it is another table but it's obviously not. Received on Mon Nov 19 2001 - 17:39:21 CET