Title self esplicative, but when I perform the join, then add field to select then make the expression I get an error. $this->getCollection()->getSelect() ->joinLeft( [ "transaction" => $this->getCollection()->getTable("transaction_table") ], "(transaction.supplier_id = main_table.supplier_id)", [ 'transaction_id' => 'entity_id', 'amount' => 'amount', 'date' => 'date' ] ) ->joinInner( [ 'supplier' => $this->getCollection()->getTable('supplier_table') ], […]