Re: unexpected results using LEFT JOIN with more than one

2002-07-04 Thread Victoria Reznichenko
Harald, Wednesday, July 03, 2002, 11:06:36 PM, you wrote: HK> >Description: HK> I use LEFT JOIN to join together two tables. And (for some 'complex' HK> reason) I want to add additional conditions into the join_condition-part HK> (and not in the WHERE part where it would belong to). But these

unexpected results using LEFT JOIN with more than one join_condition

2002-07-03 Thread Harald Kleiner
From: Harald Kleiner <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: unexpected results using LEFT JOIN with more than one join_condition >Description: I use LEFT JOIN to join together two tables. And (for some 'complex' reason) I want to add additional conditions into