>Let's see if I can define the trap better: "TableA LEFT OUTER JOIN TableB" becomes a INNER JOIN if a where condition is specified for TableB.
>
Exactly.
>>
>>But I'd rather fall into this error again than have that I currently have... :(
>
>Not sure what you mean here... :((
This is a complete off-topic, but I just wish to go back two years ago when I was making such errors, than going through life with this knowledge and no desire to proceed...
If it's not broken, fix it until it is.
My Blog