Re:Writing more legible SQL
by julochrobak on Thursday November 03, 2016 @03:00AM
(#12862079)
quick question about the indent of subclauses. How would you write a query where table3 needs to be joined with both table1 and table2? Would it change anything?
[ Parent
| on HN ]
Re:Writing more legible SQL
by combatentropy on Thursday November 03, 2016 @07:30PM
(#12869065)
No. I indent all joins to the same level, regardless of the join condition. The effect of joins is to make one large flat table, so nested indentation is an unnecessary and misleading signal.