+2 votes
1 view
in SQL by (92.9k points)

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?

1 Answer

+2 votes
by (40.3k points)
edited by

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.  

Related questions

+3 votes
1 answer
0 votes
1 answer
+1 vote
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...