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 

Result:

IDCUSTOMER_IDNAMEAMOUNT
21CUSTOMER_160000.00
34CUSTOMER_445000.00
45CUSTOMER_56000.00