I want to join entity_id column from customer_entity table with customer_id from new_info table and want to get department column value of given customer.


1 Answer 1


Try below code to get the department column value from your custom table on basis of customer entity_id field.

protected $_customerFactory;

public function __construct(
    \Magento\Customer\Model\CustomerFactory $customerFactory,
) {
   $this->_customerFactory = $customerFactory;

public function yourfunctionname(){

   $customersCollection = $this->_customerFactory->create()->getCollection();
                            ->joinLeft(['ni' => 'new_info'], 'ni.customer_id = e.entity_id', ['department' => 'ni.department']);

   return $customersCollection;

In above code:

ni = your custom table alias name and, new_info = your custom table name

Hope this solution will help you!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.