By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Newbie needs help

P: 1
hi, i am a complete newbie and got stuck. my question is about costumers and prices

Customer_ID CustomerName CustomerType
1 John 2
2 Joe 3
3 Mary 2
4 Nicky 1
5 Steve 3

and prices like:
Stock_ID StockName ListPrice Dsc1 Dsc2 Dsc3
1 vase 30 40 50 60
2 candle 25 50 35 25
3 pan 15 35 30 20
4 pencil 5 15 25 35


how can i make a query to calculate the price so that Joe is a type 3 customer and therefore discount type 3 must be applied from the list price

thanks for any help...
May 20 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.