Posts Tagged ‘Inner join vs. where’

What to use where or inner join?

Actually, I received a question like this few days ago and if such a question appear to people why not to right the answer here. :)  If you have two queries like those below what do you think is the difference?

1: select count(a.id)

2: from answer a, answerset aset

[...]