JOIN 和 INNER JOIN 的区别

2021-12-01 00:00:00 join sql sql-server inner-join

这两种连接都会给我相同的结果:

Both these joins will give me the same results:

SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK

对比

SELECT * FROM table INNER JOIN otherTable ON table.ID = otherTable.FK

在性能或其他方面的陈述之间有什么区别吗?

Is there any difference between the statements in performance or otherwise?

它在不同的 SQL 实现之间是否有所不同?

Does it differ between different SQL implementations?

推荐答案

它们在功能上是等效的,但是 INNER JOIN 可以更清晰地阅读,特别是如果查询具有其他连接类型(即LEFTRIGHTCROSS) 包含在其中.

They are functionally equivalent, but INNER JOIN can be a bit clearer to read, especially if the query has other join types (i.e. LEFT or RIGHT or CROSS) included in it.

相关文章