-----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