Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql SQL INNER Joins

Related Tutorials


 
 

Share on Google+Share on Google+

SQL INNER Joins

Advertisement
The JOIN keyword is used in SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.

SQL INNER Joins

     

The JOIN keyword is used in SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.

Understand with Example

The Tutorial illustrate an example from SQL INNER Joins. The Example helps you to know the use of SQL INNER Joins. The create table statement is used to create a tables 'Stu_Table' and 'Lib_Table'.

Create Table Stu_Table

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class  varchar(10))

Create Table Lib_Table

create table Lib_Table(Stu_Id integer(2), Lib_no integer(5))

Insert data into Stu_Table

The insert into add the records or rows to the respective tables.

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);

 Insert data into Lib_Table

insert into Lib_Table values(1,101);
insert into Lib_Table values(2,102);
insert into Lib_Table values(3,103);
insert into Lib_Table values(4,104);
insert into Lib_Table values(5,105);
insert into Lib_Table values(6,106);

Stu_Table

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10

Lib_Table

Stu_Id Lib_no
1 101
2 102
3 103
4 104
5 105
6 106

SQL INNER JOIN Syntax

The INNER JOIN keyword in SQL is used to returns you a row, when there is at least one match in both table used in SQL Query. The Syntax used for SQL INNER JOIN is used as :

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name

Use INNER JOIN in SQL Query

In this example, we make use of  inner join. The inner join return you the records from both table ,when there is atleast one match in both table respectively. The inner join is known as join. In this Query,both the tables have stu_id as primary key, based on it, return all the record from the column enlisted in select statement.

select s.stu_id, s.stu_name, s.stu_class, l.lib_no 
from stu_table as s inner JOIN lib_table as l
on l.stu_id = s.stu_id

Ruselt

Stu_Id Stu_Name Stu_Class Lib_No
1 Komal 10 101
2 Ajay 10 102
3 Rakesh 10 103
4 Bhanu 10 104
5 Santosh 10 105
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 20, 2008

Related Tutorials

Discuss: SQL INNER Joins   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com