cool, thanks for that. Till now I've only been using statements within the WHERE clause to join the tables (or LEFT JOIN where needed) but then spotted someone elses code using the INNER JOIN and was interested to know if there's a better way.
Do you know if mysql actually deals with the queries differently?
as in, it was suggested to me that when using an inner join mysql links all the tables together and then you refine that through your WHERE statements and that when joining withing the WHERE statement (eg. table_a.id = table_b.id) it loops through to do the joins? ... hmmm, I don't know if that makes sense ... but i don't know how to explain it any better sorry?
however, as i also mentioned in the article Subquery or join? (registration required, but it's free), it is more important to make sure you are getting the correct results than to worry about the internal efficiency of a piece of software that countless hundreds of man-years went into...
I don't know which might be "more efficient" .. that's up to the query execution planner .. but I do know which one is more descriptive, and that is "a join." So that's the syntax I think you should use.