Formatting - Table Joins

If there anyway with the SQL Prompt formatting to get the FROM clause to structure the table joins like the below where the first 2 tables are listed on the same row as FROM and subsequent joins are on a new line and line up on the JOIN key word??

SELECT * 
FROM TABLEA A JOIN TABLEB B ON A.ID = B.hID
              JOIN TABLEC C ON B.ID = C.hID
   LEFT OUTER JOIN TABLED D ON C.ID = D.hid

EdCarden November 11, 2020 22:40

Comments

1 comment

Hi Ed,

Thanks for your post.

I'm afraid this isn't possible in SQL Prompt currently. I would encourage you to suggest the feature on user voice: https://redgate.uservoice.com/forums/94413-sql-prompt

Robyn November 20, 2020 12:22

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Formatting - Table Joins

Comments

Add comment