Place "AND" logical operator in "JOIN" clause on new line
For readability it would be great if the "AND" operator in a join clause could be on a new line. We currently have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY AND B.DATE = A.DATE AND .......... etc.
Would be nice if we can have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY
AND B.DATE = A.DATE
AND ......... etc.
![](https://secure.gravatar.com/avatar/c449ad45189c9cd2e718c0411af4765e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Gabe commented
I strongly support this suggestion. This would make the code formatting when there are multiple join conditions (especially those involving subqueries) much clearer to read.
-
Anonymous commented
I really disliked that join conditions (and and or) cannot be put on their own separate line.