-
how to do calculation in oracle?
basically I have 2 tables and I'm trying to calculate the total sales for it.
products
pid
pname
price
Q_on_hand
Orders
Oid
Quantity
I'm trying to figure out how to write a sql state that show total sales by products:Pid and Pname. Then totalsales.
hopefull someone can help me out with this or point me out to the right direction as I don't know how to do the calculation part in oracle at all.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|