SQL question

[alex79]

What is the difference between

Select * from tablea a join tableb b on a.id=b.id
        where id=100

and

Select * from tablea a join tableb b on a.id=b.id and a.id=100

Is the second sintax faster? in first case the script will realise the join after all rows from tablea and after the join is complete will filter after the id=100 and is second case the join will be realised only after the row where id=100? (if yes then second case i think is much faster)

any opinions?

[woj]

Your best bet is to just make up some tables, and test it real quick...

[pstation]

They're essentially the same, if you're using MySQL you can prepend the query with "EXPLAIN" to view more information about the query.