MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:David T-G Date:January 15 2003 2:16am
Subject:Re: when to normalize out to a table
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Cal, et al --

...and then Cal Evans said...
% 
...
% % product then has vocalRangeTypeID as a FK.
% 
% >> Right.  That means another lookup, but it would certainly work.
% 
% If by lookup you mean another trip to the database, not necessarily, left
% join this table to your product select statement and bring in all the data
% at once.

Well, I do, though I'm not surprised that I shouldn't.  I still don't
know anything about left, right, inner, and outer joins; they sound like
belly buttons to me :-)

I've done some reading on joins and haven't figured it out yet.  Pointers
to favorite tutorials are appreciated, but I'm trying not to flat-out ask
the list to explain it to me (though that's fine with me at this point,
too).


% 
% =C=


Thanks again & HAND

mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+JMSNGb7uCXufRwARAhDlAJ4mEQfLWxMPs+liVE/aUTNs08dwcgCfeRNT
FowEnZRXzwiyBtkjLXGbaK4=
=mi3l
-----END PGP SIGNATURE-----
Thread
when to normalize out to a tableDavid T-G15 Jan
  • RE: when to normalize out to a tableCal Evans15 Jan
    • Re: when to normalize out to a tableDavid T-G15 Jan
      • RE: when to normalize out to a tableCal Evans15 Jan
        • Re: when to normalize out to a tableDavid T-G15 Jan
          • RE: when to normalize out to a tableCal Evans15 Jan
            • Re: when to normalize out to a tableDavid T-G15 Jan
          • Re: when to normalize out to a tableMichael T. Babcock23 Feb
    • Re: when to normalize out to a tableMichael T. Babcock15 Jan