Email Export Error
Please review this message below. How do I resolve this error.
It appears when I go to Admin->Email Export
Please choose the desired recipient list:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from address_book o, customers c where c.customers_id = o.customers_id GROUP B' at line 2
[select c.customers_telephone, c.customers_email_address, c.customers_lastname, c.customers_firstname, o.entry_street_address as customers_street_address, o.entry_suburb as customers_suburb,o.entry_city as customers_city, o.entry_state as customers_state from address_book o, o.entry_postcode as customers_postcode from address_book o, customers c where c.customers_id = o.customers_id GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Zencart Websites I've Designed: