RE: Parent-Child Relationship Question

2004-07-02 Thread olinux
PROTECTED] > > Subject: Re: Parent-Child Relationship Question > > __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.

RE: Parent-Child Relationship Question

2004-07-02 Thread Matt Chatterley
iginal Message- > From: David Blomstrom [mailto:[EMAIL PROTECTED] > Sent: 02 July 2004 03:13 > To: [EMAIL PROTECTED] > Subject: Re: Parent-Child Relationship Question > > And here's a follow up question... > > After looking at my database from a fresh perspectiv

Re: Parent-Child Relationship Question

2004-07-01 Thread David Blomstrom
And here's a follow up question... After looking at my database from a fresh perspective, I'm now thinking of combining tables "area" and "family" into a single table. If I do that, it would make life so much simpler if I had TWO name fields, like this: ID | Name | ParentID | Parent Na

Parent-Child Relationship Question

2004-07-01 Thread David Blomstrom
I created a database focusing on the world's nations, states, etc. that uses a "parent-child" relationship, as defined in a table named "family." I'm now trying to figure out how to query the parent, and it occurred to me that my tables might not be set up correctly. If anyone is willing to glance