General information
Category:
Coding, syntax & commands
Hello all,
I have and order line item table that for each line item record there are three distinct quantities and prices (based on product grade). If there was only one quantity and price I could run a SQL Select - Sum statement to sum all records for a particular Order; however, when I try multiple sum statements within one SQL Select I get an error.
Does anyone some ideas on how to approach this problem?
TIA
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