need help formatting JOIN Clause

I can't seem to find a setting to clean up this. Think I've tried all the settings.


  • Can you provide the sql and the formatting style?
    Have you visited our Help Centre?
  • JonasGJonasG Posts: 11 Bronze 1
    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.


Sign In or Register to comment.