Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: What's this join technique called ?

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@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 - 11:08:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US