need help formatting JOIN Clause

• 
  Can you provide the sql and the formatting style?
  

  Russell D March 28, 2019 14:02

  - 0 +
• 
  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
  

  
  
  
  
  
  
  

  JonasG January 13, 2020 13:19

  - 0 +

Add comment

Please sign in to leave a comment.