3 ms·
To me placing the join predicates immediately after the tables is more readable as I don’t have to switch between looking at the from and where clauses to figur
by pophenat 2y ago
To me placing the join predicates immediately after the tables is more readable as I don’t have to switch between looking at the from and where clauses to figure out the columns on which the tables are joined.
- buttercraft 2y agoYep, nothing is harder to read than joins scattered in random order throughout the where clause. Additionally, putting joins in the where clause breaks the separation of concerns: FROM: specify tables and their relationships WHERE: filter rows SELECT: filter columns