3 ms·
One thing I wish more people would do is to indent joins appropriately; e.g. ... Inner join a on a.... = main.. Inner join b on b... = a...
by tragomaskhalos 13y ago
One thing I wish more people would do is to indent joins appropriately; e.g.
...
Inner join a on a.... = main..
Inner join b on b... = a...
Inner join c on c... = b...
Inner join x on x... = a...
The syntax of SQL is a real basket case, readers need all the help you can give them.
- bcgraham 13y agoWhenever I see it, it takes too long to differentiate it from a bunch of random indentation. Whether this indentation system is needlessly time-consuming or necessary depends a lot on the type of query and the underlying schema.