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