what's difference between these 2 queries?

[eluser]Alpha[/eluser]
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name

compared to this:

SELECT column_name(s)
FROM table_name1, table_name2
WHERE table_name1.column_name=table_name2.column_name

i know they produce the same result but is there any efficiency issue?

thanks

[eluser]vrencianz[/eluser]
I personally prefer JOIN when reference keys used.

See http://stackoverflow.com/questions/22419...d-of-where for few more details.