Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions
 
Add your own
alternative version
Go to top

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

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

Revisions


  

Compare Revision Minor Date Status Editor
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 Vijayan
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 Vijayan

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 .

| Advertise | Privacy | Mobile
Web04 | 2.8.140921.1 | Last Updated 12 Mar 2013
Article Copyright 2011 by Hafiz Muhammad Suleman
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid