There's a collection which contains product ids. I'd like to join it with the magento table that stores paroduct names, in order to add product name to collection.
$collection = Mage::getModel("productquestions/questions")->getCollection();
$this->setCollection($collection);
$collection->getSelect()
->joinLeft(I_NEED_HELP_IN_THIS_PART_OF_CODE);
The table that's used to get collection is "nbpq_product_questions" and the column that stores product id is "product_id".
I've seen some code examples about left join collection, but I can't make it work in this particular case. Can you help me please?