Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Allow JOIN statements to be indented after selecting place on new line

Currently large join sets all align with the from statement making it harder to read.

8 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Dave B shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Sorry, it was our mistake. Formatting style like this
    FROM table1
    *****JOIN table2 ON
    *****JOIN table3 ON

    will be implemented in version 3.0

  • DH commented  ·   ·  Report

    There is no option to align JOIN statements like This

    FROM table1
    *****JOIN table2 ON ...
    *****JOIN table3 ON ...

    You will allways get this:

    FROM table1
    *****JOIN table2 ON ...
    **********JOIN table3 ON ...
    ****************JOIN table4 ON ...

    and this sucks IMHO

  • Dave B commented  ·   ·  Report

    The JOIN's should be indented but this tool seems to strip whitespace.

  • Dave B commented  ·   ·  Report

    Yes, but that indents each join an additional amount. I am requesting that all joins are at the same level but indented from the FROM statement.

    SELECT *
    FROM table1
    JOIN table 2 on...
    JOIN table 3 on ....