A couple of reasons. 1. This wasn't thought about ahead of time and there is several months worth of data in the table already. 2. I have no control over the database. This makes for a bad combination :) So. I have to work with what I have.
----- Original Message ----- From: "Eric Creese" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 07, 2004 10:08 AM Subject: RE: MySQL query question > why would you not store the id in the second table as a FK to the PK in > table one. I think that is just good table design and will easily > accomplish what you are trying to do and will more than likely return your > results much faster. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
