Formatting - Table Joins
EdCarden
Posts: 138 Silver 2
in SQL Prompt
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
Tagged:
Answers
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