% % vocalRangeType % --- % vocalRangeTypeID % === % description % === % % 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. =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 7:53 PM To: mysql users Cc: Cal Evans Subject: Re: when to normalize out to a table --------------------------------------------------------------------- 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