4 ms·
Your example raises a question I've never found a good answer to: Why use `JOIN` (and `INNER JOIN` and friends) at all when you can write the exact join more a
by spopejoy 3y ago
Your example raises a question I've never found a good answer to:
Why use `JOIN` (and `INNER JOIN` and friends) at all when you can write the exact join more accurately IMO with WHERE clauses (and using "*=" operators), and then just list all the tables in the FROM clause?
My brain always hurts trying to parse complex FROM clauses with various JOINs whereas reading the equivalent equations in WHERE clauses is way more straightforward to me.
- iamcreasy 3y agoI have had this issue, and solved it by learning that join happens from left to right. `A left join B left join C` is equivalent to ((A left join B) left join C).