New training course: Customizing SQL Prompt. Watch now.

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

Tagged:

Answers

Sign In or Register to comment.