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.