Magento – Join the two tables in Magento 2

databasejoin-tablemagento-2.0magento2

I'm trying to join two tables but it's returning wrong result could you please suggest me how to write it.

Data: From my custom table(product_id,email,id) have Product_id.

Expecting Result : join the two tables (custom_table and catalog_product_entity) to display the Product Name, Sku and Email_id

Could you please tell me how to write it?

Best Answer

This works for me. The only change between Magento 1 and Magento 2 is how to get the table name:

$collection->getSelect()->joinLeft(
   ['admin'=>$collection->getTable('admin_user')],
   'main_table.admin_user_id = admin.user_id',
   ['admin_username'=>'admin.username']);

Related Solutions

Magento – Show Data from Two Different Tables in Grid.php

You can try with following code.

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->joinLeft(
        'sales_flat_order_payment',
        'sales_flat_order_payment.parent_id = main_table.entity_id',
        array('method','cc_last4')
    );
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

protected function _prepareColumns()
{
    -------

    $this->addColumn('method', array(
        'header'=> Mage::helper('sales')->__('Method'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'method',
    ));

    $this->addColumn('cc_last4', array(
        'header'=> Mage::helper('sales')->__('cc_last4'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'cc_last4',
    ));

    -------
}

and please increase your memory size from php.ini file.

like memory_limit = 1024M.

Thanks.

Magento – Joining two collection / tables

$this->addColumn('increment_id', array(
            'header' => Mage::helper('creditlog')->__('Your orders'),
            'index' => 'increment_id',
            'renderer' => 'Spacename_Modulename_Block_Adminhtml_Action',
                )
        );

and your renderer block

 class Spacename_Moduelename_Block_Adminhtml_Action extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract
{

    public function render(Varien_Object $row)
    {


    return $row->getIncrementId().''. $row->getOrderId();



    }
}

Best Answer

Related Solutions

Magento – Show Data from Two Different Tables in Grid.php

Magento – Joining two collection / tables

Related Topic