Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Help Needed


Floob

Recommended Posts

I'm trying to use SQL to extract as a csv from MYSql all our customers address details.

 

I guess I need to query the tables:

address_book

countries

zones

 

The problem I have is that customers can have multiple addresses.

How do I only select the customers shipping address? I only want one address per customer.

 

Any help much appreciated.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...