Oracle Non Equi-Join

The Oracle Non Equi-Join enables you to join two tables where there is no direct correspondence between columns in the tables.

Oracle Non Equi-Join example

Select 
c1.customer_id, c1.name, c2.amount
From customers c1, contracts c2
Where c2.amount Between 100 and 200


Select 
c.customer_id, c.name, c.type
From customers c
Where c.type <> 'CORPORATE'
   

Select 
c.customer_id, c.name, c.details
From customers c
Where c.details Like '%CHICAGO%'