469,926 Members | 1,489 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

Newbie needs help

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
0 1185

Post your reply

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

Similar topics

2 posts views Thread by Luis Speciale | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.