sqlerudition.com
TSQL Gotcha - Putting a Condition in WHERE or ON clause: Does it Matter in TSQL? » SQLErudition.com
A filter condition can be syntactically put in the WHERE clause of the query or the ON clause too. But does it matter? No, it does not matter for an INNER join. I found this one example of an exception… Continue reading →
Aalam Rangi