Re: [GENERAL] limit left join rows to 1

2006-11-01 Thread Jure Ložar
Andreas Kretschmer wrote: Jure Ložar <[EMAIL PROTECTED]> schrieb: 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. I'm not sure if i understand

Re: [GENERAL] limit left join rows to 1

2006-10-31 Thread Andreas Kretschmer
Jure Ložar <[EMAIL PROTECTED]> schrieb: > 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. I'm not sure if i understand you correctly, but perhaps t