i have this query :
select costumers.id as cId,costumers_order.itemid,SUM(costumers_order.quantity) as totalQ, costumers.lastname, item_price.price
FROM costumers
LEFT JOIN costumers_order ON costumers.id =costumers_order.costumerid
LEFT JOIN item_price ON costumers_order.itemid= item_price.itemid
where costumers.id=1
AND costumers_order.date BETWEEN 1114898400 AND 1117576799
GROUP BY costumers_order.itemid
this is the result for example :
'cId','itemid','totalQ','lastname','price'
'1','1','2','????','1.6'
'1','14','12','????','2.6'
can i part of the query some how multiple the totalQ with the item_price.price or maybe to change the query that some how it will be done as part of the query?
more then that : is it possible in the same query to multiple the SUM(totalQ*price) of the same customer.id ===>which means some all of the total value?
thnaks in advance
peleg
