what is the difference between join and where clause?
The where clause applies to the whole resultset; the on clause only applies to the join in question. ... However, if you had included a condition on a value in the table in the outer side of the join, it would have made a significant difference.