Click here to Skip to main content
15,861,168 members
Articles / Database Development / SQL Server

Difference between And clause along with on and Where clause when used with left join in SQL Server

Rate me:
Please Sign up or sign in to vote.
4.83/5 (151 votes)
11 Mar 2013CPOL6 min read 240.5K   1.1K   188  
This article clears the differences between the On cluase and Where clause when used with left join.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
Pakistan Pakistan
I am currently working as Senior Software Engineer and I have more than 6 years of experience in Database and developing web application .

Comments and Discussions