两个表中没有“内部连接”的查询[复制]

This question already has an answer here:

这个问题已经有了答案:

• Explicit vs implicit SQL joins 11 answers
• 显式vs内隐SQL连接11个答案。

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'

1 个解决方案

#1

Just a different notation. No other difference.

只是一个不同的符号。没有其他区别。