Re: parent/child relationship in the same table.
From: James <jraustin1_at_hotmail.com>
Date: 18 Nov 2001 15:24:10 -0800
Message-ID: <a6e74506.0111181524.85a5570_at_posting.google.com>
Date: 18 Nov 2001 15:24:10 -0800
Message-ID: <a6e74506.0111181524.85a5570_at_posting.google.com>
> >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?
Generally yes, but since the parent and child are nearly identical, in this special case, they can be collapsed into one table. Received on Mon Nov 19 2001 - 00:24:10 CET