Tuesday, 15 March 2011

SQL INNER JOIN

The INNER JOIN keyword return rows when there is at least one match in both tables.

SELECT column_name
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name


The "Pur" table

OrderNo
Custname
City
1
Siva
Srivilliputtur
2
Bala
Sivakasi
3
Kanna
Madurai

The "Purdet" table

Sno
OrderNo
Qty
Rate
1
2
50
70
2
2
30
56
3
1
100
200
4
5
30
30
5
4
60
80

Example :
SELECT PurDet.OrderNo,Pur.custname, Pur.City
FROM Pur
INNER JOIN PurDet
ON Pur.Orderno=PurDet.OrderNo
ORDER BY Pur.CustName


Output  :

OrderNo
custname
city
2
Bala
Sivakasi
2
Bala
Sivakasi
1
Siva
Srivilliputtur

 Share This Post


Friendly Learn Translate to Tamil

Smilely

Services

© 2014