List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 17 1999 11:59pm
Subject:Re: complex select
View as plain text  
On Fri, 1999-09-17 15:00:07 -0400, Nathan Stratton wrote:
> > If for each row always only one of the columns H_ORG_B_TDM,
> > H_ORG_C_TDM, and H_ORG_B_TDM has a value, then I'd suggest to change
> > your table design to:
> 
> Well actually it can any cobo of the three, and this table databases
> is handed to me every month so I can't modify it.

Nathan, I can't accept this argument completely, because you're
obviously using computers ...  So you always should have the option to
transform the data as delivered into the format you like ...
And even if several of the H_ORG_[BCD]_TDM fileds can have valid
values, my suggested table scheme makes sense.

That's what I still think about these quite technical items after a
funny Friday evening with good friends and a good beer in a lovely
pub. ;)

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
unable to compile 3.23.3 with any charset besides defaultAleksandar Ivanisevic17 Sep
  • select uniqueNathan Stratton17 Sep
    • Re: select uniqueJames Manning17 Sep
    • complex selectNathan Stratton17 Sep
      • Re: complex selectJames Manning17 Sep
      • Re: complex selectMartin Ramsch17 Sep
        • Re: complex selectJames Manning17 Sep
          • Re: complex selectMartin Ramsch17 Sep
        • Re: complex selectNathan Stratton17 Sep
          • Re: complex selectMartin Ramsch18 Sep
            • Re: complex selectJames Manning18 Sep
    • Re: select uniqueTonu Samuel17 Sep
  • unable to compile 3.23.3 with any charset besides defaultMichael Widenius19 Sep
  • unable to compile 3.23.3 with any charset besides defaultMichael Widenius19 Sep
  • Re: unable to compile 3.23.3 with any charset besides defaultAleksandar Ivanisevic26 Sep
Re: unable to compile 3.23.3 with any charset besides defaultMichael Widenius27 Sep
  • Re: unable to compile 3.23.3 with any charset besides defaultAleksandar Ivanisevic28 Sep