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?

Answer 1

INNER JOIN and JOIN have the same function just to make it clearer to read, you can specify INNER JOIN. If the query has another join type such as LEFT, RIGHT or CROSS then include it.

Want to learn SQL from basics! Here's the right video for you on SQL provided by Intellipaat:

Refer to this video about INNER JOIN in detail.

You can also say that JOIN = INNER JOIN

The syntax for INNER JOIN is:

SELECT C1, C2, C3

FROM TABLE1

[INNER] JOIN TABLE2

Note: INNER Keyword is optional here. Even though you don’t mention it. By default, the INNER JOIN will be applicable.