Non Equi-Join Examples

Example 1

Select ctr.contract_id, ctr.customer_id, ctr.amount
  From contracts ctr
Where ctr.amount Between 6000 and 100000

Example 2

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

Example 3

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