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 

Result: