I want to create a select statement with whom i can get the name of a person and the total price of all his purchases from the db
i have 3 tables with fields
catalog/prod_id/price/and so on but not important
customer/cust_id/cust_name/and so on but not important
i have tried the following statement but it gave 176 as result of total purchase for each customer and that is not correct
SELECT cust_name, (SUM(prod_id) * (SUM(qty))
GROUP BY cust_name
Can anybody give me a direction on the correct statement?