Beautifier and ANSI joins

[William Robertson]

If I run the beautifier against this query:

SELECT * FROM dual d1 LEFT OUTER JOIN dual d2 ON d2.dummy = d1.dummy AND d2.dummy = d1.dummy

I get this

SELECT *
FROM   dual d1
LEFT   OUTER JOIN dual d2 ON d2.dummy = d1.dummy
                      AND    d2.dummy = d1.dummy;

which looks rather odd to me. I would prefer something like this:

SELECT *
FROM   dual d1
       LEFT OUTER JOIN dual d2
       ON  d2.dummy = d1.dummy
       AND d2.dummy = d1.dummy;

...although I expect there will be those who prefer variations like this:

SELECT *
FROM   dual d1
LEFT OUTER JOIN dual d2
ON     d2.dummy = d1.dummy
AND    d2.dummy = d1.dummy;

Any chance of this putting this on your list?

Thanks!

 

[Marco Kalter]

I have added it to the list of enhancement requests. I get this though:

SELECT *
  FROM dual d1
  LEFT OUTER JOIN dual d2 ON d2.dummy = d1.dummy
                         AND d2.dummy = d1.dummy

 

[William Robertson]

I like it to line stuff up on the left