SQL to Query customer's Sales History

[greg_beyer]

Hello, I'd like to write a simple mySQL query to retrieve customer sales data. I'll save to .CSV and download. Analyze in pivot table in excel.

So the customer info is pretty simple:

SELECT customers_id,customers_firstname, customers_lastname, customers_email_address FROM customers
WHERE <some conditions>

But then how to connect that with I *THINK* same customers_id in orders.order_total. It that where all order history is?

I just plan to paste the sql into phpMyAdmin, and run it, nothing to having to do with Admin web rendering.

Any help with the sql would be appreciated.

[carlwhat]

SELECT c.customers_id,customers_firstname, customers_lastname, 
customers_email_address, b.* 
FROM customers c
join (SELECT `customers_id`, sum(order_total)
FROM `orders`
group by customers_id
) b on c.customers_id = b.customers_id
where
...

hope that helps.

[greg_beyer]

Thanks very much carlwhat -- exactly what I was looking for. And with that I was able to tweak it a bit to get a significant list of people registered on the site, and subscribed to our email, who have never completed a purchase -- perfect candidates for a special marketing offer. Thanks for helping us build the business!

Greg

[carlwhat]

Thanks very much carlwhat -- exactly what I was looking for. And with that I was able to tweak it a bit to get a significant list of people registered on the site, and subscribed to our email, who have never completed a purchase -- perfect candidates for a special marketing offer. Thanks for helping us build the business!

Greg