join group_price to product collection

Question

When I get the product collection with :

$collection = Mage::getModel('catalog/product')->getCollection();

I get the group_price key but it's empty.

 Array
 (
    [entity_id] => 1
    [entity_type_id] => 4
    [attribute_set_id] => 2
    [type_id] => simple
    [sku] => 00000
    ......
    [group_price] => Array
        (
        )

    ......
)

And if I load the product I can get the group_price data with :

$product = Mage::getModel('catalog/product')->load($product_id);
$group_price = $product->getData('group_price');

I tried different query with joinField() or joinTable() with table 'catalog_product_entity_group_price' but without success.

How to join group_price data to the collection with a join query ?

I would like to avoid iterating the collection to load each product and get the group_price.

Answer 1

Use ->addAttributeToSelect('group_price')