You are talking about preference vs functionality.
Under tool -> Option -> Choose editor and reformat the statement listed in the form you prefer. This should solve your problem.
From: Andre Vergison [mailto:email@example.com]
Sent: Friday, January 26, 2018 11:39 AM
Subject: RE: [Toad for SQL Server - Discussion Forum] Oracle Formatting Options - JOIN direct under FROM
RE: Oracle Formatting Options - JOIN direct under FROM
Reply by Andre Vergison
The left hand column of keywords (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY etc.) represent distinct clauses of the statement. Adding the JOIN, LEFT and NATURAL keywords (and probably some others as well) would make it a mixed list of everything. As it stands now the right hand side of the FROM is exactly the table reference list in all its simplicity or complexity.
Having said that, there is a notable exception : multiple AND or OR operators in the WHERE clause:
SELECT table1.id, table2.id
WHERE id3 = id4
AND field3 > field3
AND field5 = field6;
I guess some prefer this for cosmetic reasons. But AND and OR are little keywords.
How should we align the join operators? Something like this perhaps:
SELECT table1.id, table2.id, table3.id, table4.id
JOIN table2 ON table2.id = table1.id
LEFT JOIN table3 ON table3.id = table1.id
NATURAL JOIN table4;
It’s just when statements become complex (many and complex clauses) that design constraints tend to conflict… And I wonder if it does help to make the statement more understandable?
I welcome suggestions whatsoever.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for SQL Server Forum notifications altogether.
Toad for SQL Server - Discussion Forum
this post as spam/abuse.