PL/SQL Inner Join
Oracle PL/SQL Inner Join
Equijoin is also called simple join or inner join – the select of two different tables as a condition containing the equality operator.
Inner Join Example:
Select o.id, o.customer_id, c.name, o.amount From offers o, customers c Where o.customer_id = c.customer_id And o.amount > 2000