General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi All
I have a SQL question which seems to be simple but I can’t seem get it to work. I am using Sybase ASA, not FoxPro. I have a list of price levels based on quantity. For example, 100 items sell for 2.00 250 items sell for 1.50 and 500 items sell for 1.00. I need a query to find the proper line based on the quantity being purchased. For example, if 400 items were being purchased then I need to get the 250 qty price.
Thanks for your help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only