Receive all updates via Facebook. Just Click the Like Button Below

Blogger Widgets
/

Watch Intro About My Website ! ! !

Sunday, 3 November 2013


The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

SQL RIGHT JOIN Syntax

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

In some databases RIGHT JOIN is called RIGHT OUTER JOIN.


SQL RIGHT JOIN Example


The "Persons" table:

Id
LastName
FirstName
Address
City
1
Navis
Anto
Madras
TVL
2
Ji
Bala
Bombay
TVL
3
Christopher
Franklin
America
KK

The "Orders" table:

Id
OrderNo
Id
1
77895
3
2
44678
3
3
22456
1
4
24562
1
5
34764
15

Now we want to list all the orders with containing persons - if any, from the tables above.

We use the following SELECT statement:

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
RIGHT JOIN Orders
ON Persons.Id=Orders.Id
ORDER BY Persons.LastName

The result-set will look like this:

LastName
FirstName
OrderNo
Navis
Anto
22456
Navis
Anto
24562
Christopher
Franklin
77895
Christopher
Franklin
44678


34764

The RIGHT JOIN keyword returns all the rows from the right table (Orders), even if there are no matches in the left table (Persons).

Tagged:

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...