Re: Nested Tables?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Fri, 2 Feb 2001 12:00:26 -0800
Message-ID: <95f3jd$3i$1@spiney.sierra.com>

Nested Tables:

Assume you have a db which holds consumer info, such as name, address, telephone, email address, and some product info.

A real simple example would be for handling of multiple telephone numbers.

That is, you might have a name (probably first, middle, last), an address (like address1, address2, city, state, postal code [for U.S. consumers]),
and telephone(s), perhaps a work phone, daytime phone, nighttime phone, etc.

One might wish to store telephones as part of the name record using a "sub-table" of
telephone numbers [and associated "type" as work, home, etc.]

<jdorlon_at_my-deja.com> wrote in message news:95ek4v$2ic$1_at_nnrp1.deja.com...
> Can anyone describe a scenario of when nested tables would be desired?
> They just seem so complicated to me that they are not worth the
> effort! Am I missing something?
>
> Thanks!
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 02 2001 - 14:00:26 CST