Allow the option for SQL formatting of nested inner join on an outer join to indent the nested inner join.
When you have a nested inner join to an outer join, such as:
SELECT a., b., c.*
FROM
A a
LEFT JOIN B b
INNER JOIN C c on b.bid = c.bid
ON a.aid = b.aid
It should allow an option to indent the nested join further to show that it is nested
5
votes
Peter Mikovitz
shared this idea
We’ve released support for indenting nested joins in version 8 of SQL Prompt as part of our new formatting system.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
Kind regards,
The Prompt Team
-
Lee Robinson
commented
I think nested JOINs should always be enclosed in parentheses to show the nesting. Then the options for parentheses would handle the formatting.