Inner Join (mysql)

[zacarias]

These two queries are "equivalent", that is, they give the same result.

#1
select * from one, two where one.job_id = two.id

#2
select * from one inner join two on one.job_id = two.id

What I want to know is: is there any significant diference between using "explicit" Joins (#2) and using "implicit" Joins (query #1) in MySQL?

Those are simple queries, I want the general picture (for bigger/more complex queries with other clauses).

Thanks.

[tomhath]

You will get the same rows back either way. But to a purist, the ON clause of an explicit join controls how the tables are joined, and the WHERE clause controls which of the resulting rows are excluded from the result.

When you use the comma form, you have to lump both the join condition and the exclude condition together. Same result, slightly less clear what you intended.