Hi,

I am joining two tables 'sales/order_item_collection' and 'sales/orders' by 'order_id', so that afterward i can filter sold products by 'store_id' and 'product_name'

Here is the code: $orderTable = Mage::getSingleton('core/resource')->getTableName('sales/order'); $itemsCollection= Mage::getResourceModel('sales/order_item_collection') ->join(array('ord'=>$orderTable),'e.order_id = ord.entity_id');

Why is this join not working?

Thank you