Question: what is the difference between equi join and inner join in oracle?
Answer: What is the difference between Equi Join and Inner Join in SQL? An equijoin is a join with a join condition containing an equality operator. ... An inner join is a join of two or more tables that returns only those rows (compared using a comparison operator) that satisfy the join condition.