Click here to Skip to main content
12,349,778 members (27,247 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions

Stats

121.3K views
976 downloads
189 bookmarked
Posted

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

, 11 Mar 2013 CPOL
This article clears the differences between the On cluase and Where clause when used with left join.

Revisions


  

Compare Revision Minor Date Status Editor
16 - publicly available Yes 12-Mar-13 2:39 Available Hafiz Muhammad Suleman
The article has been approved
15 No 12-Mar-13 2:01 Pending Hafiz Muhammad Suleman
Updates in content. 28 changes had been made.
12 No 5-Mar-13 10:25 Available Sean Ewington
Updates in content.
11 No 5-Mar-13 6:48 Pending Hafiz Muhammad Suleman
Updates in content. 8 changes had been made.
10 No 18-Feb-13 8:30 Available Smitha Nishant
Updates in content. 66 changes had been made.
8 No 13-Feb-13 9:12 Available Sean Ewington
Updates in content.
7 No 13-Feb-13 4:58 Pending Hafiz Muhammad Suleman
Updates in content. 25 changes had been made.
2 No 23-Aug-12 6:52 Pending Hafiz Muhammad Suleman
minor correction , it was shoing 6 rows , i changed to 5 rows as one reader pointed out
1 No 25-Jul-11 17:00 Available Smitha Nishant

License

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

Share

About the Author

Hafiz Muhammad Suleman
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 .

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160621.1 | Last Updated 12 Mar 2013
Article Copyright 2011 by Hafiz Muhammad Suleman
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid