In old releases inner joins where coded like this
Select * from table_a, table_b where table_a.some_column = table_b.some_column and ... (further conditions)
Using ansi standard joins you can rewrite this as
Select * from table_a inner join table_b on table_a.some_column = table_b.some_column where ... (further conditions)
The advantage is, that the reader is told which columns are used for the join and has not to solve the puzzle which conditions describe the join and which describe the where condition.
What about downvoting all answers using old style inner joins until they are rewritten in ANSI style ?
Not intended as punishment, but as community pressure to enforce the improved coding style?
Can you give me hints, which of the following items caused the downvoting of my question
- wanting to enforce some kind of sql syntax in the answers of SO
- the proposal to use downvotes to achieve this