Re: parent/child relationship in the same table.

On 18 Nov 2001 15:24:10 -0800, jraustin1_at_hotmail.com (James) wrote:

>Generally yes, but since the parent and child are nearly identical, in
>this special case, they can be collapsed into one table.

What did your logical model look like? I'm wondering how a logical model that identifies two different entities yields a physical model that seems to have just one.

In any case, unrolling a dubious self-join might be in order. (No pun intended.)

-- 
Mike Sherrill
Information Management Systems