I have a products table and sale rate table.
Products table contains all the products and their original cost. Sale rate table contains only the products that are on sale, and their discount rate.
I want to create a query that calculates the final discount price for all the products.
Products table: All products
ProductID
OrigPrice
SalesRate table: Only the products that are on sale
ProductID
DiscountRate
What I want is FinalPrice table: All products
ProductID
FinalPrice = OrigPrice * ((100-DiscountRate)/100)
I don't know how to create a query that will display all the productIDs. My query only returns the final price of products that are on sale.
Please help! Thank you. - sjh
Products table contains all the products and their original cost. Sale rate table contains only the products that are on sale, and their discount rate.
I want to create a query that calculates the final discount price for all the products.
Products table: All products
ProductID
OrigPrice
SalesRate table: Only the products that are on sale
ProductID
DiscountRate
What I want is FinalPrice table: All products
ProductID
FinalPrice = OrigPrice * ((100-DiscountRate)/100)
I don't know how to create a query that will display all the productIDs. My query only returns the final price of products that are on sale.
Please help! Thank you. - sjh