Collection joins in magento.

gistfile1.txt

These are just some snippets for me to reference quickly for commonly used magento items.


FOR EAV collection


$collection->joinTable(
                    array("alias" => "module/entity"),
                    "join=join",
                    array("field_alias" => "field"),
                    "condition",
                    "joinType" );

For NON-EAV table

$collection->join($table, $cond, $cols = '*')