Magento Articles and Tips for Developers

 
<?php
 
        $collection = Mage::getResourceModel('mybrands/orders')
            ->addFieldToSelect('name')
	    ->addFieldToSelect('order_id');
 
        echo '<pre>';
        print_r($collection->getSelect()->__toString());