mysql - 查询两个表不带 "inner join"

Question

这个问题已经有答案了:

Explicit vs implicit SQL joins (12 个回答)

已关闭 9 年前。

我想知道这两个查询有什么区别，哪一个的性能最好？

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

或

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

Answer 1

只是一种不同的表示法。没有其他区别。