limit left join rows to 1

[Jure Ložar <jure.lozar@xxxxxxxxxxx>]

Hi.

Is it possible to limit number of left join rows that match condition to 
1? I don't want to have hits from first table multiplied when more then 
1 row matches on left join condition.

Thank you
Jure