need help formatting JOIN Clause

joe12pack

I can't seem to find a setting to clean up this. Think I've tried all the settings. https://www.screencast.com/t/YlEF2UT8Ma8

Russell D

Can you provide the sql and the formatting style?

JonasG

Hi!

I have the same issue, I want to format the "and" indented with join, like when using and in a where clausule.

-- a. I get this when using "and" on a join, looks very silly
inner join dbo.Jobs as j on j.Id = jr.JobId
                             and j.ReportId = 'ROL001'
-- b. I can accept this
inner join dbo.Jobs as j
    on j.Id = jr.JobId
        and j.ReportId = 'ROL001'

-- c. I want this
inner join dbo.Jobs as j on j.Id = jr.JobId
    and j.ReportId = 'ROL001'

In the Formating styles / Clauses / Join, the closest is to:

ON Condition / Place ON keyword on new line / Indented

result like b.

/Jonas