Need SQL help

[Guest]

Can someone please help me out I am trying to get a list of all the customers email address out of the database where the customers place a order.

 

please send me the sql code

[peloke]

The customers email address is actually stored in the orders table so you could simply

 

select customer_email_address from orders.

 

If you want more info you could do

select o.customers_email_address,op.products_name,op.products_quantity from orders o, orders_products op where

o.orders_id=op.orders_id

 

Not sure why osCommerce stores the email in the orders table as well as the customer table, maybe you can specify a new email when your buy..

[wizardsandwars]

Keep in mind that this will select all customers that have an order of any type of order status.

 

For example, if you have an order statrus of "PayPal Processing" or "Cancelled" or "Returned" or "Pending" all of these will be included.