Re: What's this join technique called ?
Date: Fri, 21 Oct 2005 13:23:31 GMT
Message-ID: <nZ56f.19268$q1.2491_at_newsread3.news.atl.earthlink.net>
"Andy Dingley" <dingbat_at_codesmiths.com> wrote in message
news:24gfl1p1tejv5c4n909c9mjpr0eq911q0j_at_4ax.com...
> On Thu, 20 Oct 2005 13:32:27 GMT, "David Cressey"
> <david.cressey_at_earthlink.net> wrote:
>
> >Before you can even begin to ask questions about normalization, you need
to
> >see whether your columns are or are not well designed.
>
> Well _my_ columns are very well designed! This isn't my abomination, I
> just had to work round it.
>
> Yes, the obvious fix would be to dump the "intratableid" column and
> replace it with three separate columns for sectionid, subsectionid etc.,
> one (and only one) of which would be non-null.
>
Excuse me. I thought that the example you provided was your example. Still, it illustrates the problem nicely. Received on Fri Oct 21 2005 - 15:23:31 CEST