Tuesday, 15 March 2011

SQL FULL JOIN

The FULL JOIN keyword return rows when there is a match in one of the tables.

Syntax 

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


Pur

OrderNo
custname
city
1
Siva
Srivilliputtur
2
Bala
Sivakasi
3
Kanna
Madurai

PurDet
sno
OrderNo
qty
rate
1
2
50
70
2
2
30
56
3
1
100
200
4
3
30
30
5
1
60
80


Example :
SELECT Pur.OrderNo as PurOrdNo,Pur.custname, Pur.City,PurDet.Orderno as PurDetOrdNo
FROM Pur
Full Join PurDet
ON Pur.Orderno=PurDet.OrderNo 

ORDER BY Pur.CustName


Output :

PurOrdNo
custname
city
PurDetOrdNo
NULL
NULL
NULL
5
NULL
NULL
NULL
4
2
Bala
Sivakasi
2
2
Bala
Sivakasi
2
3
Kannan
Madurai
NULL
1
Siva
Srivilliputtur
1


Quick Links :
      Refer Left  & Right Join ....  Click Me 

 Share This Post


Friendly Learn Translate to Tamil

Smilely

Services

© 2014