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.
Jan 09, 13