SQL: Joins and Where clause, a mix to be aware (Logical Query Processing Phases)

Hi, Recently I got engaged in a discussion, Which I feel the ones that really was an eye opener for me and some thing i thought trivial played an important role in my day today work. The conversation went as What is the effect of WHERE¬†clause in a (INNER/LEFT/RIGHT) join, if moved to ON clause Read More …