Another good reason for not using where for joining: it can lead to unintended cartesian joins.

3. Don’t Use ‘where’ for joining: Some people perform the inner join using the ‘where’ clause, instead of using the “inner join’ cla…
5 Most Common SQL mistakes you should avoid
253
7
Anmol Tomar
Bryan Martin
·Follow
Jul 18, 2022
--
Another good reason for not using where for joining: it can lead to unintended cartesian joins.
--
--
Written by Bryan Martin349 Followers
·74 Following
Always learning.
No responses yet
Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams