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.
8
votes
Henk Havenga
shared this idea
-
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.