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
Please sign in to leave a 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.