What is good and what is wrong between:
from x inner join y on x.id = y.id
and especially why
select * from x, y
where = x.id y.id
As Personal I think the 1 is much better because:
- It clarifies the notion of join: where its only for my filters, not for the bullshit to join
- Join if the word is there is a reason. it's like for the replacement of C while + if/then. it works the same, but why not use for?
- It is more compact
- (A little bad faith assumed I think) Method 1 is that of those who left to join wrong and nothing to understand, the 2 is the method of "true"
So, what do you do?