Oracle Inner Join

The Oracle Inner Join is a join of two or more tables that returns only those rows that satisfy the join condition.

Oracle Inner Join example

Select 
c.contract_id, p.product_id, p.amount
From products p, contracts c
Where p.product_id = c.product_id
And p.amount > 3500 ;


Select 
cu.customer_id, cu.name, 
c.contract_id, p.product_id, 
p.amount
From 
customers cu, 
products p, 
contracts c
Where c.customer_id = cu.customer_id 
And p.product_id = c.product_id
And p.amount > 3500 ;