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.
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.