Magento join two tables: To join two custom table in the database you need to add specific query with table to get the desired result. Here is the code that will impart solution for joining two tables in Magento.
$collection = Mage::getModel('module/model_name')->getCollection();
$collection->getSelect()->join(Mage::getConfig()->getTablePrefix().
'table_name_for_join', 'main_table.your_table_field ='.Mage::getConfig()
->getTablePrefix().'table_name.table_field',
array('field_name_you_want_to_fetch_from_db')); $collection = Mage::getModel('sales/order')->getCollection();
$collection->getSelect()->join( array('order_item'=> 'sales_flat_order_item'),
'order_item.order_id = main_table.entity_id',
array('order_item.sku')); When it comes to children, there’s one universal truth: the right toy can spark imagination, build skills, and make memories…
In today’s digital age, where screens and gadgets dominate our children’s lives, there’s something heartwarming about a well-loved plush toy…
In a world dominated by screens and fast-paced routines, it’s easy to forget the simple magic of a toy in…
In the heart of Delhi’s vibrant streets lies a world where imagination meets innovation — the magical universe of toys.…
When was the last time a toy truly amazed you—not just as a product, but as a thoughtful tool for…
In the digital age, the way we experience childhood has changed, but the essence remains the same—imagination, exploration, and joy.…