Sunday, 20 November 2011


NoneEqui Join - The NoneEqui Join is a join condition in two table involving different attributes from two table. It is use to check condition and give a result.

We have following "Emp_Salary" name table:          We have following "Salary_Limit" name table:

NameSalary
John265000
Jay150000
Bhavesh75000
Jaimin66500
Dolar80000
Ajay24500
Rahul45000
Quene35000


Level_NoLow_LimitHigh_Limit
1125000
22500150000
350001100000
4100001500000


Left Outer Join Example

Syntax:
SELECT Table_Name1.Column_Name,Table_Name2.Column_Name 
 FROM Table_Name1,Table_Name2
  WHERE Table_Name1.Column_Name 
 BETWEEN Table_Name2.Column_Name AND Table_Name2.Column_Name;
Example Statement:
SQL> SELECT Emp.Salary.Name,Salary_Limit.Level_No 
 FROM Emp.Salary,Salary_Limit
  WHERE Emp.Salary.Salary
 BETWEEN Salary_Limit.Low_Limit AND Salary_Limit.High_Limit;
Example Result:

Emp.Salary.NameSalary_Limit.Level_No
Ajay1
Rahul2
Quene2
Bhavesh3
Jaimin3
Dolar3
John4
Jay4
























SQL GUIDE

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers