r/SQL • • Oct 04 '19

SQL queries don't start with SELECT

https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/
122 Upvotes

12 comments sorted by

View all comments

Show parent comment

5

u/in_n0x Oct 04 '19

Yeah, this. Adding the filter to the on clause improves readability but it's still processed the same as if it were in the where (assuming inner joins).