sql - Is inner join the same as equi-join?

Question

Can you tell me if inner join and equi-join are the same or not ?

Answer 1

An 'inner join' is not the same as an 'equi-join' in general terms.

'equi-join' means joining tables using the equality operator or equivalent. I would still call an outer join an 'equi-join' if it only uses equality (others may disagree).

'inner join' is opposed to 'outer join' and determines how to join two sets when there is no matching value.