Difference between JOIN and INNER JOIN

Both these joins will give me the same results:

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

vs

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

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

Does it differ between different SQL implementations?

---

它们在功能上是等价的，但INNER JOIN可以更清晰一些，特别是如果查询中包含其他连接类型（即LEFT或RIGHT或CROSS ）。

---

Just typing JOIN performs an INNER JOIN by default.

For all others, one picture is sometimes worth more than hundreds of words:

Image courtesy of CodeProject

---

---

不，没有区别，纯粹的语法糖 。

链接地址: http://www.djcxy.com/p/15126.html

上一篇: INNER JOIN ON与WHERE子句

下一篇: JOIN和INNER JOIN的区别