Queries in two tables without "inner join"

Question

I wonder what is the difference of these two queries and which one hás the best performance?

SELECT employee.*, company.name  FROM 
company,
employee
WHERE
employee.company_id = company.id AND
company.id = '365'

or

SELECT employee.*, company.name  FROM 
company 
INNER JOIN employee ON employee.company_id  = company.id
WHERE
company.id = '365'

The performance is the same. The second is much, much, much, much preferable. — Gordon Linoff, Mar 26 '14 at 19:21

score 2 · Accepted Answer · answered Mar 26 '14 at 18:38

2

Just a different notation. No other difference.

answered Mar 26 '14 at 18:38

Lodewijk Bogaards

1 Answers1