Re: Database Design

From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Wed, 25 Jul 2007 16:42:08 +0100
Message-ID: <46a76f51$0$1608$ed2619ec@ptn-nntp-reader02.plus.net>

Paul wrote:
> Hi all,
>
> I have posted a question in the Database design and theory ng, but I
> expect a lot of you will have suggestions to help me (and that ng
> doesn't seem very active).
>
> The post is here:
>
> http://groups.google.co.uk/group/comp.databases.theory/browse_frm/thread/5db717bb37ca5b0f?hl=en
>
> Any help would be appreciated.

Find out about "aliases"; in effect you can create multiple "instances" of your Phones table, and join to them "all"

You may need to use outer joins to join to your aliases if some of your phone numbers are "missing"

BugBear Received on Wed Jul 25 2007 - 10:42:08 CDT