General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Simple SQL approach
I am so rusty with VFP I have to re learn everything when the boss gives me a project.
Here is my issue, should be simple for you guys.
I have a cursor that consists of data records similar to this
Fields; Order, Item, quantity, unitprice, extendedprice (qty * unitprice)
each order may have multiple items
I want to create a crusor that has each unique order with a total
If I do a SELECT SUM(extendeprice) it gives me the sum of all orders.
I only want the sum of the extended price for each order.
since I only have one cursor involved, am I correct in using SQL statements.
data example shown as a snapshot jpg image.
I want to create a cursor with each individual order as a record with the sum price of all items on that order.
Sorry for asking something so basic, but I am really out of touch with vfp lately.
steve
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