So, I have subscribers collection:
$subscribersCollection = Mage::getModel('newsletter/subscriber')->getCollection();
I want to join customer collection to it by email, so I did next:
But in this way I only join
customer_entity table, but not all the customer collection.
I think about also join other customers tables. Is there any better way to join customer collection?
I have tried
$customerCollection = Mage::getResourceModel('customer/customer_collection'); $customerCollection->getSelect()->join(array('cus'=>'newsletter_subscriber'),'cus.subscriber_email = e.email'); $customerCollection->getItems()
Now it work, thanks