Auto Formatting question - Right align JOIN to FROM

Adam12312312

Hi, I am wondering if there is a way to right align the JOIN keyword to FROM in the auto formatter, so the formatting looks like the below?


When I set the Option 'JOIN keyword alignment' to 'Right aligned to FROM' I get the following instead:

Which is right aligning INNER but not JOIN.

Is there a way to right align JOIN to FROM?

cperez

Thanks for the update Adam,

I was able to test this locally and at this time, it does not appear you can right align on the INNER or LEFT portion of the JOIN clause using a custom formatting style. Fortunately, I was able to find a vote for this issue currently being held on our SQL Prompt feature suggestion page which I will link below.

https://redgate.uservoice.com/forums/94413-sql-prompt/filters/new?query=Right align on INNER JOIN

I encourage you to vote on this issue so it can possibly be introduced in a future version.

Cheers,

Christian Perez

cperez

Good Afternoon,

In order to better assist you, could you confirm which version of SQL Prompt you are utilizing? 

Adam12312312

Hi, I am on version 10.14.10.7538

Adam12312312

Thank you Christian!