Hi all. I've got a greenhorn question but I didn't find the right
keywords to get Google to answer it for me.
Is it more efficient to put conditions in a JOIN instead of sticking
them all at the end in the WHERE clause, or is that just a matter of
preference? Putting conditions in the JOIN It
It's about syntax and clarity, both for the reader and to the query
optimizer. The JOIN conditions belong in the ON sub-statement
precisely because they are the predicate for the join and serve to
grow the data set .. the WHERE query is supposed to specify limiting
conditions on that superset.