更新时间:2023-11-29 23:12:16
这应该有效:
$select = $this->getConnection()->select();
$select->join(
array('order_shipping'=>$this->getTable('sales/order')),//alias=>table_name
$this->getConnection()->quoteInto(
'order_shipping.entity_id = order_grid.entity_id',
Mage_Sales_Model_Quote_Address::TYPE_SHIPPING
),//join clause
array('shipping_description' => 'shipping_description')//fields to get
);
$this->getConnection()->query(
$select->crossUpdateFromSelect(
array('order_grid' => $this->getTable('sales/order_grid'))
)
);
如果需要,请查看我的扩展名 :)
HTH
If you want, take a look at my extension :)
HTH