Can you tell me if inner join and equi-join are the same or not ?
See Question&Answers more detail:osCan you tell me if inner join and equi-join are the same or not ?
See Question&Answers more detail:osAn '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.