Mysql Left Join Force Group By
<p>I have notice that when I use a left join to another table, My data duplicates itself and I don't have more option than make a group by so that I could have the correct rows.  </p>

<pre><code>SELECT * from tbla a left join tblb b on a.id=b.id_a
group by a.id
</code></pre>

<p>Are there a way to make a left join returning correct rows with no duplicate?</p>