title: Multiple condition in Join Magento
body: <p>Can Anyone tell me?</p>
  
  <p>How can i write this type of query in magento
  (Multiple condition in on)</p>
  
  <pre><code>SELECT Customers.CustomerName, Orders.OrderID
  FROM Customers
  LEFT JOIN Orders
  ON (Customers.CustomerID=Orders.CustomerID and Orders.status = 1)
  </code></pre>
  
  <p>//I know this type</p>
  
  <pre><code>$collection = Mage::getModel('module/model_name')-&gt;getCollection();
  $collection-&gt;getSelect()-&gt;join( array('table_alias'=&gt;$this-&gt;getTable('module/table_name')), 'main_table.foreign_id = table_alias.primary_key', array('table_alias.*'));
  </code></pre>
  
  <p>How can i add multiple condition in JOIN ?</p>