How do I select specific columns on table join in propel?
<p>I need to select specific set of columns from both the table using propel orm 2.0.0. The equivalent query is as below</p>

<pre><code>select b.name as brand_name, b.grade, d.name as dealer_name, d.number
from brand as b join dealer as d
on d.id = b.dealer_id;
</code></pre>

<p>I am struggling where the necessary columns on both the tables have same name but need to join using different column.</p>

<p>Help me with the propel php code and also with proper reference site. The document at official site is not a good tutorial.</p>