Subversion
Written by: Lorna Jane Mitchell
Featured Refcardz: Top Refcardz:
  1. Git
  2. DNS
  3. Data Mining
  4. Spring Data
  5. Subversion
  1. Spring Data
  2. Subversion
  3. Spring Config.
  4. Spring Annotations
  5. Data Mining
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!

Link 903073 thumbnail
User 1049989 avatar

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

Condition in ON cluase of OUETR JOIN Effects
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.
Vote up
Vote down
  • 4
  • 1
  • 124
  • 227
SaveShareSend Tags: , ,

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)