0

What is a difference between a use of Join keyword and using equijoin condition without the use of Join keyword? Does it cause any performance issue if Join keyword not used in SQL query? If yes then how is it related to performance.

MrNeilP
  • 349
  • 1
  • 5
  • 19
  • 3
    An explicit `JOIN` is the right way to express an inner join, and has been for decades. The comma in the `FROM` clause is archaic, and less powerful than the `JOIN` keyword. But, in most databases, the two are compiled into the same code. – Gordon Linoff Sep 19 '16 at 00:51
  • [This question](http://stackoverflow.com/questions/5471063/is-inner-join-the-same-as-equi-join) might also shed some light. – dave Sep 19 '16 at 00:58

1 Answers1

0

An equijoin returns only the rows that have equivalent values for the specified column. An inner join is a join of two or more tables that returns only those rows that satisfy the join condition.

Mr. K
  • 380
  • 3
  • 15