0

I am trying to join two tables like below

    $objectManager =  \Magento\Framework\App\ObjectManager::getInstance();

    $collection = $objectManager->get('Advance\Module\Model\Method')
    ->getCollection()->addFieldToFilter('stores', ['finset' => $store_id]);

    $collection->getSelect()->joinLeft( ['shippingrate'=> 'shippingrate'], 
    'shippingrate.method_id = main_table.method_id', ['main_table.method_id']);

This is returning all data from two tables. I could not get specific columns from the end result.

2
  • Try this answer magento.stackexchange.com/a/166292/84221 May 3, 2021 at 4:24
  • Try with shippingrate table's column in array like $collection->getSelect()->joinLeft( ['shippingrate'=> 'shippingrate'], 'shippingrate.method_id = main_table.method_id', ['shippingrate.column_name']);
    – Mital Shah
    May 3, 2021 at 6:49

1 Answer 1

0

You can refer to this example of mine:

protected function filterOrder($payment_method)
    {
        $this->sales_order_table = ""main_table"";
        $this->sales_order_payment_table = $this->getTable(""sales_order_payment"");
        $this->getSelect()
            ->join(array('payment' =>$this->sales_order_payment_table), $this->sales_order_table . '.entity_id= payment.parent_id',
                array('payment_method' => 'payment.method',
                    'order_id' => $this->sales_order_table.'.entity_id'
                )
            );
        $this->getSelect()->where(""payment_method="".$payment_method);
    }

Your Answer

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

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