>I had a customer that was constantly >changing prices, and if I only did joins to the product table to get >price, things would get ugly. You could optionally maintain a >"price_history" table or something, but that overcomplicates it if you >ask me.
Doug covered the basics real well here, I'll just add that another good reason for not joining the product table is so you can delete products no longer being used, while maintaining your order history. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
