JOIN Layout Suggestion

pburleson

We've been looking at using SQL Prompt 3 to apply a consistent layout to our SQL Code and after working with our team, we have a suggestion. Within the Data Statements, for JOINS, allow having the ( on the next line not be indented. Also, we'd like to have the ON on the line with the join and the start of the clauses on the next like.

For example, here's how SQL Prompt would do it now:

SELECT
staffId,
staffName,
a
FROM
personnel
INNER JOIN (
SELECT
a
FROM
b
) AS ab
ON personnel.a = ab.a

Here's what we'd like:

SELECT
staffId,
staffName,
a
FROM
personnel
INNER JOIN
(
SELECT
a
FROM
b
) AS ab ON
personnel.a = ab.a

The ON with the new line is less important than having the sub query not indent an extra time.

Thanks,
Patrick

Linda Hawksworth

Thanks for your forum post. I have logged your layout request in our tracking system. I have placed a watch on this issue so that I am informed if/when the status changes. It will be considered for a future release of SQL Prompt although I cannot guarantee if/when it will make it in.