Peter Friswell Posted April 28, 2010 Share 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 Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 28, 2010 Share 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...? Link to comment Share on other sites More sharing options...
Guest Posted April 30, 2010 Share Posted April 30, 2010 @Peter If you still need this, please pm me. Mike Link to comment Share on other sites More sharing options...
voodoo89 Posted June 15, 2010 Share Posted June 15, 2010 You mean what ..sql query ? SELECT Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.