What’s the difference between “where” clause and “on” clause when table left join?
The where clause applies to the whole resultset; the on clause only applies to the join in question. In the example supplied, all of the additional conditions related to fields on the inner side of the join – so in this example, the two queries are effectively identical. However, if you had included a condition … Read more