Comment Comment by pophenat 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. parent pophenat 2 years ago