Skip to content

Instantly share code, notes, and snippets.

@nikolazic
Created February 7, 2014 18:08
Show Gist options
  • Save nikolazic/8868343 to your computer and use it in GitHub Desktop.
Save nikolazic/8868343 to your computer and use it in GitHub Desktop.
Magento Join Alias
// NO Alias
$collection
->join('color', 'color.color_id = main_table.rug_color_id', 'color.name as rug_color_name')
->join('color', 'color.color_id = main_table.binding_color_id', 'color.name as binding_color_name')
->join('binding', 'binding.binding_id = main_table.binding_id', 'binding.name as binding_name');
//ALIAS
$collection->getSelect()->join(
array('binding_color' => $collection->getTable('color')),
'binding_color.color_id = main_table.binding_color_id',
'binding_color.name as binding_color_name'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment