Search code examples
phpsqlmagento

Magento joining 2 tables


I want to join admin table and another profile table in magento how should I do this?

I want to join $userModel = Mage::getModel('admin/user'); table and

$vendorModel = Mage::getModel('vendorprofile/vendor');

Solution

  • Riaz.try the below code ---

               $collection = Mage::getModel('admin/user')->getCollection();
        /* start inner join .vendorprofiletable is the 
    Mage::getModel('vendorprofile/vendor') module table */
              $collection->getSelect()->join( array('vendorprofile'=> 'vendorprofiletable'), 
            'vendorprofile.vendor_id = main_table.entity_id', array('*'));
    

    Here suppose vendorprofile.vendor_id = main_table.entity_id is the relation between two tables.

    if you want to get query of join then echo $collection->getSelect();

    Hope it will be help you.