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

[GENERAL] limit left join rows to 1

2006-10-31 Thread Jure Ložar
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 ---(end of broadcast)--- TIP 6: explain an

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