Hi Prateek,

Check this article

http://support.microsoft.com/default.aspx?scid=kb;en-us;176480

Well it doesnot really elaborate on the internal logic and implications of AND and WHERE clauses for Outer Joins but it does throw little light on how they work.