Link Details

Link 903073 thumbnail
User 1049989 avatar

By indiana_joy
via sqlknowledgebank.blogspot.in
Published: Jan 09 2013 / 08:15

Where we are making JOIN, a lot of developer uses extra condition within the ON clause of the JOIN. In my review I find that some developer added a lot of condition in the ON clause (they are including WHERE condition within the ON clues of the JOIN). Please remind it that the extra condition of ON clause of JOIN can affect the OUTER JOIN. This article is related to it.
  • 4
  • 1
  • 228
  • 231

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (4)



Voters Against This Link (1)



Debugging JavaScript
Written by: Ashutosh Sharma
Featured Refcardz: Top Refcardz:
  1. Design Patterns
  2. OO JS
  3. Cont. Delivery
  4. Java EE7
  5. HTML5 Mobile
  1. Java EE7
  2. Spring Annotations
  3. Git
  4. Java
  5. REST