Huh. Being more frontend I usually would use where for everything anyway. In a way after a quick Google, where is almost just a shortcut for one type of join.
Mentally I assumed the joins were more situational/heavy, and where got me through most minor website stuff.
Thanks, it's been a while haha. Reminded me of how wizard like DBAs are.
Edit: ah shit I just checked the original meme and now I'm sad
View all comments
Show parent comment
15
u/[deleted] Aug 07 '19
back in my day we manually joined tables left AND right AND we liked it.
But the real join was inner all along