I am trying to get the total cost for each order per customer. here is as far as I have been able to get...
select
ordertbl.ordno
, ordertbl.orddate
, sum(ordline.qty)
, product.prodprice
, sum(ordline.qty * product.prodprice)
from
ordertbl
, ordline
, product
where
ordertbl.ordno =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.