Is inner join the same as equi-join?

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.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)