Hacker News new | ask | show | jobs
by renhanxue 601 days ago
Also, using the ON clause is consistent with the syntax for outer joins, where you have to use it (because there's a very important logical difference between putting the condition in the ON clause vs in the WHERE clause).