Alignment of columns in ON-clauses when having multiple conditions

Hi there

I'm searching for the option to align columns in Joins. Currently, code is formatted as shown:

SELECT *
FROM foobar
     LEFT JOIN barfoo ON (
    foobar.a = barfoo.a
        AND foobar.b = barfoo.b
    )

However, I want the columns in the columns in the ON-clause aligned as this:

SELECT *
FROM foobar
     LEFT JOIN barfoo ON (
            -- columns should be aligned
            foobar.a = barfoo.a
        AND foobar.b = barfoo.b
    )

I think I once had the proper checkbox ticked, but it somehow got reset and I can't find it anymore. Where do I have to look_

Thanks!

Christian

0
1 comment

Hi Christian,

Formatting of join conditions on new lines intended is currently listed as feature request:

https://youtrack.jetbrains.com/issue/DBE-17971/Format-JOIN-condition

The closest you can get to your desired goal is by tweaking the Wrap ON/USING and Place ON/USING options.     

1

Please sign in to leave a comment.