>1) The AND portion of the JOIN ON clause is not truly a JOIN condition at all.
>You should move that into the WHERE clause. (This might in fact cause the
>problem you mention, except that you said the problem still occurs when you
>remove the AND clause.)
Not correct.
http://support.microsoft.com/support/kb/articles/q268/9/06.asp