问题：

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? 不同的SQL实现之间是否有所不同？

---

解决方案：

参考一： https://stackoom.com/question/2N8u/JOIN和INNER-JOIN之间的区别
参考二： https://oldbug.net/q/2N8u/Difference-between-JOIN-and-INNER-JOIN