need help formatting JOIN Clause

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
Tagged:

Answers

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






Sign In or Register to comment.