SQL non Equi Join

has average rating 7 out of 10. Total 14 users rated.

<<PreviousNext>>

Description

The SQL NON EQUI JOIN uses comparison operator instead of the equal sign like >, <, >=, <= along with conditions.

Syntax

Select *
FROM table_name1, table_name2 
WHERE table_name1.column [> |  < |  >= | <= ] 
table_name2.column;

Parameters

Example

Here is an example of non equi join in SQL between two tables

Sample table : orders

Sample table : customer

To get 'ord_num' and 'ord_amount' columns from 'orders' table aliased as 'a' and 'cust_name' and 'working_area' columns from 'customer' table aliased as 'b' after joining said two tables with following condition -

1. 'ord_amount' of 'orders' table matches any of the 'opening_amt' of 'customer' table,

the following sql statement can be used :

SELECT a.ord_num,a.ord_amount,b.cust_name,b.working_area
FROM orders a,customer b
WHERE a.ord_amount BETWEEN b.opening_amt and b.opening_amt;

Output

Outputs of the said SQL statement shown here is taken by using Oracle Database 10g Express Edition.

See our Model Database

Here is a new document which is a collection of questions with short and simple answers, useful for learning SQL as well as for interviews.

You might be interested to read the following topics :

• SQL Equi Join
• SQL Joins
• SQL Outer Join
• SQL Natural Join
• SQL Left Join
• SQL Self Join