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.
W
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 se
