http://froogle.google.com/froogle?q=sql+for+dummies&btnG=Froogle+Search
http://froogle.google.com/froogle?q=sql+for+smarties&btnG=Froogle+Search
http://froogle.google.com/froogle?q=mysql+paul+dubois&btnG=Froogle+Search
(first book in the list)
I can personally recommend the first two and while I've never met him, I do
not hesitate to recommend the author of the third. :)
These are all portable, energy efficient and almost never crash unless
thrown.
Also, using the table structures we've discussed, something like:
Select p.productID,
p.title,
v.description as range
from product p left join voicingType v on p.voicingTypeID =
v.voicingTypeID
where productID = 4
should get you a result set back with a productID, title and the description
of the range.
=C=
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-----Original Message-----
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:17 PM
To: mysql users
Cc: Cal Evans
Subject: Re: when to normalize out to a table
-----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) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- 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-----
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
