Here is my data let say:
In Products table has a cost field and data = 102
In Pricing table has a range from low to high cost fields = 12, 45, 110, 175, 200 with respect to a range of sell_Price fields 20, 50, 200, 220, 230
If anyone can get me a simple query string that will be a great help?
Thanks for posted a reply so quick.
I’m sure did not make myself clear here.
What I want is that the Query should return a sell price correspond to the product cost.
The sell price can fall in between any two sell_price data in the pricing table, and this value make it harder to form a query string.
102 ?? need this number and it is not necessary in the Pricing table.
Hope this help clear my question.
OK - but what kind of logic are you using? It's not immediately intuitive why you would link 110 to 200, 175 to 220, and 200 to 230. What "rule" are you trying to implement?
Aaron Alton | thehobt.blogspot.com
- Marked as answer by Saykao Friday, July 31, 2009 7:41 PM