hello guys! i need help on sorting out the data on my MySQL.
i have 2 tables on my SQL: table_products (id,name,price,discount_id) table_discount (disc_id, amount) i would like to sort the discounted price. SELECT * FROM table_products ORDER BY (price-(SELECT... blah blah WHERE disc_id=discount_id) <-- i know my SQL is wrong.. how would i do it on MySQL when not using sort() of php? i hope you guys understand.. thanks Send instant messages to your online friends http://uk.messenger.yahoo.com [Non-text portions of this message have been removed]
