Peter Friswell Posted April 28, 2010 Posted April 28, 2010 Please will someone help me write an SQL query that allows me to extract the following data from my shop and then export it in CSV or similar for use elsewhere. customers_email_address customers_firstname customers_lastname entry_company entry_city entry_state entry_postcode entry_country_id customers_telephone customers_fax customers_info_date_account_last_modified Thanks for your help Peter
♥mdtaylorlrim Posted April 28, 2010 Posted April 28, 2010 The customer_company is not associated with a customer. It is associated with an order. So, what are you really wanting? A customer list BASED on orders made but not duplicating...what. I can order with my name and ship to three different companies. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.