Page is a not externally linkable
- Code, Content, and Presentation
---- design question: store products priced in different currencies
Skier88 - 7:57 pm on Mar 3, 2011 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4274305.htm
Did a little more searching, and this should be closer to the right query:
Do you think this is too inefficient?
SELECT a.*,b.rate FROM product_info a LEFT JOIN currencies b ON a.currency=b.name ORDER BY a.msrp*b.rate
Brought to you by WebmasterWorld: http://www.webmasterworld.com