-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Cal, et al --
...and then Cal Evans said... % % 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. :) I've heard good things about the third (well, *lots* of good things; I've heard at least *some* good things about all three) and it's on my list as soon as I have some cash to buy it. % % These are all portable, energy efficient and almost never crash unless % thrown. *grin* % % 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. OK. First I have to get my head around your table structure, which I'll do in more detail now that I have an example against it, and then I have to figure out how to read that to learn a bit about how it works -- but I'm very grateful! % % =C= % % * % * Cal Evans % * Stay plugged into your audience. % * http://www.christianperformer.com Thanks & HAND :-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+JNvxGb7uCXufRwARAjZvAJ9L0KsXMh/agnA+ITYGiVUb5zysegCgz5Bi Yye0dODpRPKB5MmsdViAm04= =FGyI -----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
