Sunday, 20 November 2011



Inner Join/Equi Join - The Inner Join/Equi Join is a join condition involving common attributes from two tables.

We have following "Student_Detail" name table:

S_NoS_NameTotalPercentage
1Jay50777.84
2Ajay48774.92
3Bhavesh46972.15
4Jaimin46371.23
5Dolar42565.38

We have following "Stu_Detail" name table:

Enrollment_NoS_NoS_Name
19210900941Jay
19210900642Ajay
19210900743Bhavesh
19210900924Jaimin
19210900875Dolar


Join Example

Syntax:
SELECT Table_Name1.Column_Name,Table_Name2.Column_Name 
FROM Table_Name1,Table_Name2
WHERE Table_Name1.Column_Name=Table_Name2.Column_Name;
Example Statement:
SQL> SELECT Stu_Detail.Enrollment_No,Student_Detail.S_No 
FROM Stu_Detail,Student_Detail
WHERE Student_Detail.S_No=Stu_Detail.S_No;
Example Result:

Enrollment_NoS_No
19210900941
19210900642
19210900743
19210900924
19210900875

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