This email was created by [your name] who thought you would be interested in the following Article:
"Difference between And clause along with on and Where clause when used with left join in SQL Server"
This article clears the differences between the On cluase and Where clause when used with left join.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!