Jim Metcalf
asked on
adding a column based on function to query output
I am requesting 2 columns from my table with another column being created with values from math function. (output of query)
col1(qty) col2(price) col3(qty * price)(this is not in the table)
5 8 40
can someone write out the query based on clientid = 5 please.
that will give me the desired result
table = orders
client id = 5
qty
price
col1(qty) col2(price) col3(qty * price)(this is not in the table)
5 8 40
can someone write out the query based on clientid = 5 please.
that will give me the desired result
table = orders
client id = 5
qty
price
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.