sql - JOIN和INNER JOIN之间的区别(Difference between JOIN and INNER JOIN)

Question

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

  ask by driis translate from so

Answer 1

它们在功能上是等效的，但是INNER JOIN可能更清晰易读，尤其是在查询中包含其他INNER JOIN类型（即LEFT或RIGHT或CROSS ）的情况下。