Re: What's this join technique called ?
From: Andy Dingley <dingbat_at_codesmiths.com>
Date: Thu, 20 Oct 2005 17:08:33 +0100
Message-ID: <24gfl1p1tejv5c4n909c9mjpr0eq911q0j_at_4ax.com>
Date: Thu, 20 Oct 2005 17:08:33 +0100
Message-ID: <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. Received on Thu Oct 20 2005 - 18:08:33 CEST