News for hackers. Stuff that matters.
Re:Best practices for writing SQL queries by mulmen on Saturday April 10, 2021 @04:21PM (#26764780)
ON should be on another line because it gives context to bo.author_id = au.id.
Re:Best practices for writing SQL queries by hobs on Saturday April 10, 2021 @05:09PM (#26765132)
You never write NOT ON, so no, I'd disagree that its required for all the inequalities you express.
Re:Best practices for writing SQL queries by mulmen on Saturday April 10, 2021 @05:31PM (#26765319)
Huh?

ON is required by the syntax. Why start every line with a keyword that describes the line except the ON portion of a JOIN? It's inconsistent and has no clear benefit.